I wouldnt presume to tell you what mods to try. What one person may treasure another disdains.
You couldn't go wrong with just starting off with GWX Gold Supermod which is basically a compliation of many of the best mods orchestrated into a fine rework of the SHIII sim.
It comes with a host of optional mods that can be applied (and more importantly removed) on top of the basic GWX mod.
Then there are many enhancement mods that work with and complement GWX Gold. You should perhaps read the associated threads to determine if they appeal to you and any related info about possible mishaps....'cause Murphy's Law is always in effect.
GWX is probabaly the most widely used supermod but don't ignore the other supermods. Many like those too but of course require seperate installations in order to work.
__________________
|