These mods are MASSIVE texture packs that hold many refurbished, redone, and even reimagined textures. They can range from the smallest of things like a cup to the largest of landscapes like a castle wall! Here we have listed the best overhauls to start off with. You can customize and switch between textures to find the best looking one's that fit your taste. Don't forget that these are just general texture packs. There are smaller one's that sometimes look better than the overhaul's but don't have a lot included since the packs are only for a specific item or area. This means that these overhauls are mearly bases to cover most of the game's textures while the other smaller mods focus on improving smaller or more random objects such as only ingrediants or even just certain pieces of furniture. If you want the BEST results don't use the official 2k textures by Bethesda.
And here are some notable texture authors that either make random textures with no rhyme or reason and are not all in one pack or download link. It's recommended you download all of their works but it's not necessary.
These are non-specific collections of mods that you can use to customize your game. You can interchange these textures to make the game the way you want it to. Now for even better looking textures, you gonna have to get some specific overhauls that work on one or two aspects of the game itself.