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.
I was actually just looking through that and found a few mods that I liked. (Higher res armor,weapons,creatures)
I don't like mods that add new thing like armor or weapons as there is already tons of them that I've never hard in the vanilla game. I like the mods that make the game look better and run better. But any mods that you like go ahead and post them because I would still like to see them.