well for Battlefield 1942 its mostly for terrain textures. They are low res and covered by a detail mesh which ads fine detail over the top.

Requires no real telent other than to be able to create a custom brush and paint roads and stuff.

I want to learn a few photoshop tricks so I can design a decent looking website to host my portfolio of levels on.