I like that hibernate is supported by Adobe ( soon be be Railo aswell ) without installing more "stuff". I looked at Transfer but this was about the same time I heard about Hibernate in CF9 so I put that on hold. I also like not having to use XML where possible.
The feature that I'm most looking forward to is direct integration with Apache Lucene for [cfsearch]. I just found out that Railo also uses Lucene, so it will make it easier to transition over to Railo if I choose to do so.
The ColdFusion Builder IDE is pretty nice too. Better than CFEclipse, and it sounds like future versions are going to have some really cool stuff.
I think the Hibernate stuff sounds pretty amazing, though I haven't had the opportunity to use it. I could see us eventually integrating it into CFWheels for developers that have CF9 installed. Or it can simply become another option for the model layer in your MVC framework of choice.
Sounds like a great way to go. We develop websites using fusebox mainly but with Transfer lexicons - so having hibernate built in or as a plug in would be a great plus.
Right now, we really go out of our way in the model layer to make up for the lack of performance of CF's CreateObject() function. We're releasing a version of Wheels tomorrow that does some hackery at the database level so you can calculate additional properties like fullName, based concatenation of the firstName and lastName fields (for example). All this so we can still use the much-faster query object without losing that OOP feel.
Unless I'm misunderstanding how it works, Hibernate integration really has the potential to give us back real objects without slowing down performance.
To be exact, object creation is 8x faster in ColdFusion 9 than it was in ColdFusion 8.01. We just put the first draft together for a formal performance brief that we hope to release soon.
IMO, Hibernate should scale and handle load better than any of the cf orm solutions. This isn't meant as a knock to Transfer and Reactor because I love both of these solutions for different reasons, it's just that Hibernate has a bigger usage/test base thanks to Java and .NET.