First off, for those that don't know, Adventure Maps are user-created maps that add a story and provide a goal to Minecraft rather than just surviving in the wilderness. I've played a few Adventure Maps in my time playing Minecraft and some of them are amazing, but a lot of them are pure crap.
Some good ones I've played include:
Black House
Labyrinth
Prof Grizwold and the Curse of the Pyramid
The Redmurk Mystery
If anyone wants to post any maps that they've played and thought where good (or bad) please go ahead and do so and leave a review if you want to as well. It also kind of helps if you say the length of the map as I've seen some really short ones out there too...