Well you will get different opinions. Here is mine. These all work well when installed in the order below
Gameplay Mods:section
1-Red Storm Rising Free Roam Mod, (Lot's of fun)
2-Playable SubsMod, (always updating!! and fun)
Graphics mods:section
3-Cold Waters enhanced navigation map, (very useful)
4-My Background Map and Torpedo Load Indicator Mod ( useful eye candy)
The other mods are fine I'm sure but I can't advise you on the install order. I have not tried them yet.
It's a good starting point