I ran a modified version of Sceptre Tower. And we really enjoyed it. The first half is the best bit - it details a ruined city, and has a lot of locations and NPCs that are detailed just enough to let the DM roll with it. And that was a huge part of the adventure for us - the PCs would go somewhere that had a few notes on the map, and I'd whip together a few encounters. Loved it.
The actual adventure (read as: the encounters) are alright, but to me weren't where I got the bang for my buck. Because, as someone else mentioned elswhere, encoutners in 4e are easy - the hard part is setting up an adventure, and Sceptre Tower does that beautifully. I skipped the second "dungeon" in this adventure (the catacombs) and went straight to the tower. There were too many encounters in this part, which I cut out, but it was still pretty fun.
The ending is a bit anti-climactic, but I fixed that (and boy, did I!).
Highly recommend it. I ran a bit of Shadowfell, but hated it (blech). And Trollhaunt bored me to tears just reading it, so it never got used (except for the monsters and maps). Sceptre Tower is the only adventure i read that fits my fast and loose style.