I would say that graphics mods are probably the best, most mods come with tutorials or readme's telling you how to add them into the game.
But yeah, there its lots of different texture and graphics mods out there, you are best off finding a mods website such as...