I've never played with any community content installed. Must be the prevailing and lofty notion that "the game is perfect as-is"
But just browsing things, Cilantro's Restoration Pack
looks like a good one to grab. If you try some of these mods, I'd be interested to hear what you found to be worthwhile.