Of Sound Mind!!!! Without a doubt, it is my favorite D&D adventure of all time. It was an absolute pleasure to run, and from what I've gathered from my players at the EN chicago gameday 2, they all sorta liked it too!
Since I started a nautical campaign within the Sea of Fallen Stars I used the little start-up adventure within the "Pirates of the Fallen Stars" 2e sourcebook. It is a brilliant opening for any nautical campaign.
Also I like the challenge of champions modules within Dungeon since they are a good starting point for characters to get to know each other.