Since we're talking about the quality of his games I'll try to comment what I think about each one of them.
RE2 - Awesome, a timeless classic, but slightly overrated.
DMC - Kinda crappy, unresponsive controls, awkward camera, one of his worst.
VJ - VIEWTIFUL, a love letter to the genre. The visuals fooled me for a long time. I was young, thought it looked stupid and rented on a whim, but man, what a ride. I loved every second of it.
Okami - Beautiful, charming, amazing art and sense of adventure, too bad it is piss easy. One of his best.
Bayonetta - Masterpiece, full of content, style and challenge, Kamiya's most complete game. It does have some flaws, mainly the QTEs, but it does not detract from the experience.
TW101 - Utter garbage, couldn't finished, tried many times, the design is too flawed, game doesn't feel as polished as his other efforts, couldn't get into the combat. A misfire in my eyes, but I'll try to play again someday.
Overall I would say he is pretty good and one of my favorite directors in the industry. I'm really hoping for the best with Scalebound.