Randis Albion is an artist whose work is all over the place thematically, but constantly awesome. As a conceptual concept artist working heavily in Adobe Photoshop, he has designed works for video games and other media.
It's extremely tough to pick just one example of his work, but the Pikachu piece "Gonna Catch 'em All", above, is one of his newest. More to see at the slightly NSFW link.
http://www.conceptart.org/forums/showthread.php?t=166776 (Scroll down) More, smaller images at DeviantArt here.
i guess that sounded really snooty. but its true.
http://en.wikipedia.org/wiki/Conceptual_art
http://en.wikipedia.org/wiki/Concept_art
Massive Black
http://www.massiveblack.com/MBwebolution/illustration.php
Nate's NSFW
http://www.n8vandyke.com/personal_illustration.html
http://www.coro36ink.com/conceptart/charactercreature.shtml
stop putting cheesy links here it isnt neat at all.
i mean there are ten of thousands of these game illustrators around the world and there are much better stuff out there.
it almost sounds like some shameless promotion of certain site.
and yes concept artist and conceptual artist are two totally different thing.