Creating a texture look real

i wanna create a texture look real like in black ops and stuff. but when i use photo shop and stuff it looks too basic i have Maya and 3ds max what can i do to make it look real and not fake? i know this doesn't have to do with unity but please help!

I would say most of the time the lighting/lightmaps gives more realistic look than good textures. Most of the time I would say that object with just AmbientOcclusion looks better than object just with Diffuse texture.

But yeah you need to read some tutorials. I found links in this thread useful: http://forum.unity3d.com/threads/68432-Need-Advice-About-Textures

Making reallistic looking textures will require art skills that you can learn from Forums and other 2D Graphic Websites