Modern: Dangerous Waters, or it's predecessor Sub Command that you already know. Go to the according forum to learn more.
Historic/WWII: Silent Hunter III (atlantic), Silent Hunter IV (pacific). Opinions on which is the better game, are split. More about these in the according forums!
Good luck, and welcome, btw.