I am a big fan of ColdFusion just haven't used it for awhile. When I used to build sites, I would use the Illudium PU-36 Code Generator to create my MVC coding based on MYSQL. It worked great, but as I am getting back into ColdFusion it is not working with CF10. Being out of the ColdFusion world for a while, I am not sure how things are being done.
I liked the way the PU-36 generator would layout the basic structure(MVC) from the database and I could go from there - even though every change would take a little work. I still understood the starting structure and how to make the changes from there. It provided a good start.
Is the hibernate part of ColdFusion what I should be looking at.
I liked the the MVC basics based on a generator.
The PU-36 thing only deals with the data-abstraction layer as far as I can tell, and not really anything to do with MVC. The Hibernate wrapper in CF10 would replace all that for you these days.
As far as the MVC side of things go, there's a bunch of frameworks out there, and which is the most appropriate for you is a subjective thing, so you probably need to do your own investigations there. I've messed around with Coldbox a bit, but find it a bit heavy for my liking (it just does too much). However other people swear by it. I have had a superficial look at Framework One, which is much lighter and more how I'd want a framework to be (mostly out of the way). And there are a bunch of others, which Google will help you investigate.