Jordan,
The code I have for multiple sites is as follows:
var sites = SiteInfoProvider.GetSites().WhereEquals("SiteIsOffline", 0).And().WhereEquals("SiteStatus", "RUNNING");
// loop through all sites in this instance and create a new provider for each one
foreach (SiteInfo site in sites)
{
// Creates a new StorageProvider instance
AbstractStorageProvider mediaProvider = new StorageProvider("Azure", "CMS.AzureStorage");
// Specifies the target container
mediaProvider.CustomRootPath = "cmsstorage";
// Makes the container publicly accessible
mediaProvider.PublicExternalFolderObject = true;
// Maps a directory to the provider
string path = string.Format("/{0}/media", site.SiteName);
StorageHelper.MapStoragePath("~" + path, mediaProvider);
}