As impressive as photo-realistic renders are, I've personally only stuck to more stylized techniques; I find them to have more of a wow-factor for me. Plus they're quicker, and I'm a lazy sack of crap.
(bad example, yet still a selfplug)

Even still, I totally wanked up the front on that one anyways.







):