Well, I'm humbled that lelionx mentioned me...I don't see my stuff as ranking with the others mentioned! Anyway, in addition to some of the others mentioned above, check out Catharina Przezak's gallery for near photorealistic textures. Zrincx also does fine realistic texture work...any realism in my stuff is due to him. And though I believe SteffyZZ no longer maintains a gallery here, you might check her work at zs3d.com.