what i mean by this is how do you add detail and make it look really
realistic such as -

http://forum.toribash.com/showthread.php?t=164079

or something such as this -

http://forums.toribash.com/showthread.php?t=166726

or this -

http://forums.toribash.com/showthread.php?t=182078
because i dont know how to add detail like these but i dont want to add filters i want to use tools to make it look good.
I use photoshop CS3 extended edition so please could someone give me a tutorial please, I dont want to be able to make it to detailed to the point that it looks rubbish but so it looks epic. If someone can help that would be great.
In a way I'm looking for a guide/Teacher also i'm quite new at this so please dont give me too much hard work,
I also like basic styles like,

Danzos style i love his texturing ways.
I like rocklee2's texturing i think is great he's the person i would like to do art like the most.
pate5 he's just epic O_O hands down even if i could be as half as good as him that would be great, so if anybody could give me tutorials on how to do this i wouldnt be able to say how happy i am.
thank you and please give me some tutorials or some tips.

and i only do

aliens
tribal
animals
robots
and others .
but not really humans maybe humanoids/cyborgs.

Start with a photo manipulation program like GIMP or ADOBE PHOTOSHOP. Then just either draw in the textures or add layers of photos and textures to make it look how you want. There are many tutorials on this.

Okay,
that didnt really help but thanks.
anymore suggestions ?
anyone..

Well you need to buy tex items that can be in diffrent sizes such as:
-128x128
-256x256
-512x512
128 items have the worst quality while 512 items have the best quality.
256 items are in the middle and i would suggest that you should buy them.
But its up to you to decide.