Mollymutt's Super Mario 64 Retexture
Mollymutt’s Super Mario 64 texture pack is a full retexture of the game. He recreated every texture in his own vision of how Super Mario 64 might look with more modern texture capabilities.
According to Mollymutt, many of the textures were created with 3DS Max.
As it covers the entire game, it is a good choice if you want to play through Super Mario 64 again.