I pretty much exclusively played single player community modules.
Standout Modules:
Honor Among Thieves
The Prophet Series
Almraiven

A Dance with Rogues was ok.