Hope this isn't breaking the rules to much but I stumbled across this fellow over at CGSociety and had to post it. This isn't game-art related but it is 3d art related and incredibly inspirational work, if it gets removed then I understand.
The work done here is probably some of the most realistic stuff I've ever seen. This is my first time seeing Liam Kemp's work so I'm just floored.
CGSociety - Liam Kemp
LiamKemp.com