If I were you I would stick to mods that mainly deal with aesthetics, fixes, atmosphere, and possibly rebalance. While there are a lot of mods that are fun themselves you should try to keep the game as vanilla as possible then screw around with silly mods later when you get bored. So while the two i linked originally are fun I wouldn't recommend them starting out.
The most recent mod list I've been following is BTB's mod list ,but as its kinda riding the line on the whole NSFW rule so I won't link it.