hey banksta - if you really want to learn texturing, the best thing to do is to take a single object, model it and then focus on getting it textured, lit and rendered as best as you can. just look around your house and pick objects that interest you, but provide a bit of a challenge.

At the moment, it seems as though you are creating an entire scene and then getting bored half way through texturing - which is what a lot of people do - and so it just ends up looking half finished. by focusing on a single or a couple of objects you are ensuring that you have a limited amount of texturing work - therefore you can see the end goal and have something to work towards. just a suggestion.