That kind of realism isn't going to just fall into your lap, you need to practice. And the best way to practice is using the video tutorials provided by this site and google searching for other tutorials. And upon these tutorials is more practice. Realistic texturing. As far as I know there is absolutely no plug in that will make your character and scene look more realistic.

Practice