Is there mods that add more missiles/nuclear missiles?
Typhoon SSBN would bee also pretty cool.

Krayzeenbk has done a few (Atlas and Soviet R-7). Check units forum.

Edit: and no, I don't think anyone has made a mod that specifically adds new kinds of missiles to the game.

Atlas
http://forums.civfanatics.com/showthread.php?s=&threadid=74228

R-7
http://forums.civfanatics.com/showthread.php?s=&threadid=73253

Has anyone made Typhoon?

I belive so.

Here you go. :)

http://forums.civfanatics.com/showthread.php?s=&threadid=36997