Skyrim Texture Mods?

So I'm going to get my new graphics card (7970) in the mail in a few days and was looking to prepare my games for it. I know that skyrim has severe console-itis and am wondering what are some good texture mods are? Also some just good fun mod suggestions would be appreciated, thanks in advance for any responses.

As far as mods and patches go, make sure you get the unnofficial patch, and the 2k texture mods. 

Moonpath to Elswyr(?) is really cool.

Edit: Its Elsweyr.

Also, as good practice, make sure you have saved copies of your .ini files (: you don't wanna end up like me and completely jack up your settings messing around with mods.

Yeah, I hate mods that I have to do a lot of work just to install. On a side note: I really want to pick up Skyrim, but I'm afraid that the legendary edition will go on sale cheap during the steam sale.

Idk summer sale is coming up, i think i got my copy for like 10-15$s on one of those flash sales or whatever they are called. I also hate the alot of work mods, trying to get skyui  (i think it was called, the good inventory thng) to work was a pain in the ass, i ended up needing to launch it from a different exe file than the one thats tied in to steam </4.

Cant u just delete the ini file and do the verify game thing on steam, that worked for me to get mine back when i was playing with some inventory mods.

If you have the texture RAM, I think there is a 3 or 4K version made by the same person/people who made the most popular 2K one.