This goes back to every ancient argument over technology. I bet cave men once argued over what sort of flint made better fire, or like people who refuse to acknowledge that peddle shifters are faster than a stick.
A CMS is where it is at man. Every and any good website should be database driven. CMS will change everything and here is the best part about CMS. It appeals to the most advanced user and it appeals to the novice. It can change your life when it comes to web development.
My friend, who is a web developer by profession, exclusively uses drupal. He builds sites for people using drupal, and built in modules along with his own home brewed coding, as well as his original graphic design work. He can built them fast and efficiently and drupal allows the owner of the site maintain it and update it with out having to bother him for everything. Then when they want tweaks or major over hauls they can call him and contract him out again for another job.
My website is built off of drupal. I installed it in about 5 minutes and was already creating content. You don't have to use their prebuilt system or product, you can make it your own.
Look at CMS this way, it is not a full blown solution to web development. Instead it is a framework, which you have the ability to tweak or completely overhaul with that frame work still being there under the hood. In another regard you can take that frame work and just add a bit of CSS and you got yourself a custom built site based off of that CMS's framework.