And here is our list of TXPCKS.

Texture Fix Patcher - http://www.minecraftforum.net/viewtopic.php?f=25&t=46173
This Texture Patcher will help you fix any problems that the texture packs may have such as blocks showing smaller blocks of fire or see through areas on them.

Texture Packs
Gerudoku
PainterlyPack

I'm gonna throw up painterly since everyone asks for it! (Also it's customizable just check it out in the hotlink i'll throw onto the edit on Baitens post

This mod makes the game so much more pleasant to look at without even changing the textures. It's easy to install, though trying to uninstall it has the potential to corrupt all your save data, if you don't back up your worlds. http://www.minecraftforum.net/viewtopic.php?t=55700

Photorealism Texture Pack: 256x256 glory! (scroll down on the first post to see what it looks like.)

If you have a computer that can handle it of course.
Also, there are a lot of minecraft mod links you should check out toward the bottom as well.

I use Animal Crafting, an Animal Crossing texture pack.
http://www.minecraftforum.net/viewtopic.php?t=48464