You listed some pretty massive examples. IMHO I can't speak for certain, but I think most of the games industry is still on hand painted textures. BTW in your example you forgot to mention Wii, which is still the best selling console by a pretty significant margin, and Facebook. Diablo 3 is also the best selling PC game…
I'm still not too sure what you're trying to ask or say here. The quoted text is especially baffling, do you think you could elaborate? Everyone has certain areas they excel at and tend to do what they're best at. Most people who work on high-poly sculpting or next-gen type characters CAN do low-poly work you see in mobile…