Anybody use any mods that massively improve the game for them? What do they do?

Depends on what you wanna do. I've heard good things about all kinds of mods.

I guess one that everybody should use is Realistic Lighting with Customization. Looks great and actually saves you some frame rate under some circumstances.