I'm also ambivalent to Ravenloft as a setting. Gothic horror, particularly filtered through the old Universal and Hammer films, is fertile ground but it doesn't mesh with D&D's core aesthetic of platemail-wearing fighters, elven archers and so on. You have to take an awful lot of D&D out of D&D to make it work.
As for Strahd himself, my players killed him 25 years ago and I've killed him twice as a player. I'm pretty much done with him. I'm disappointed in WotC's passion for rehashing the D&D intellectual properties rather than creating interesting new NPCs, settings and monsters. It doesn't much matter to me though, since I don't buy adventures and settings anymore, but I really wish they had a grander imagination.
Of course, Ravenloft's true use is a bunch of monsters, horror rules, Vistani fortune-telling and other content that you can crib for your non-Ravenloft games so it's not like it will be completely useless for most D&D gamers.