The key to being able to pull it off, is to be able to be very good at making photoreal, cartoon, etc...

THEN choosing one style and making it your own.

Picasso was an amazing painter... what was his quote? "At the age of 12 I could paint like michaelangelo, but it took me a lifetime to learn to paint like a child" something like that.

If you want to make CG look like paint, you should also be able to make it look like a photo if anyone ever calls you out