I hated them back in the OD&D era, and our group never ran them- I guess we were an outlier. We always had smaller locations and a variety of them. I still don't like or run the traditional D&D mega-dungeons.
When I run something big I prefer a non-traditional setting- Tegel Manor, The Black Monastery, Parlainth, The Big Rubble, etc.