Shadowfell isn't a bad expansion for content reasons - the quests and zone and ideas are all interesting and fun - the problem was the way it was implimented and marketed -
I've said this so many times its dumb now but red alerts should not flag in public slayer zones - it makes the shadowfell zones idiotic because you red alert no matter what you do -
Menace was the best in my opinion simply because it was a nod to the fanbase who loved the Drizz't books - they gave the fans what they wanted and they did it well.
Ravenloft was arguably the best of SSG's expansions - it was extremely well done - Death House is top 5 DDO quests of all time - Castle Ravenloft quest was so well done it was immaculate.
Sharn is the expac I see people run the most because the loot was the best - 3 piece great set bonuses. Sharn is a very good expansion and the Eberron specific content generally very good - it baffles me why Eberron is not more popular with players because it is an extremely rich setting - very very interesting - We have only seen 1% of Eberron in DDO - its an epic landscape. Would be fab if we could see the Mournlands or time travel to the Last War. We really need Kalashtar and Changelings and different warforged bodytypes