I had to disable a ton of high res texture mods and drop to 2xAA to get the game to run smoothly. With that said, I still have a few texture mods installed - High Quality Eyes, Realistic Water, and Real Ice. VRAM hovers around 1050-1100MB in most areas, I could realistically start adding back some of the other high res packs but many of them are simply no longer needed now with the DLC pack.
High Quality Shields, Enhanced Night Sky, Improved NPC Clothing, Millenia Weapon Retexture, No More Blocky Faces, Skyrim HD Retexture Landscape, Skyrim HD, Skills Interface Retexture, Mountain and Rock Textures.
All those mods I've now left disabled since the DLC addressed all of them, except the last one. Are the mods better quality? Quite possibly, but overall not worth it at the moment plus I want to get a feel for just how high quality this DLC pack is. So far it's quite awesome (the shields and weapons in particular).