ok im starting to get the modeling side of things under control but when i finish models im not sure how to texture them.

I've played a round with hypershade etc but they always seem to look..well...crap

any links for some tutorials or suggestions are greatly appreciated.