My colleague Joe lays out an argument that ColdFusion really doesn't have any true ORM frameworks. I have to agree with him. I love Transfer and have used it many times to help speed my ColdFusion development. And while I think Transfer is the best option we have at this time, it really isn't a true ORM, but is really an SQL abstraction layer. If anything, I'd say it is a ROM (relational-object mapping) since everything is still driven from the database up into the object model. I have no idea if that is a real name, but it should be. ;-)
Having worked extensively with Hibernate in the last few months, I can see the real power in having a system where the database is driven by the object model rather than the other way around. It's amazing to define an object model, and then run the application and watch Hibernate generate the schema for you, or change the object model and watch Hibernate update the schema as necessary. In most cases, you don't even have to think about the database at all. It will be interesting to see what the ColdFusion team have done with Hibernate in CF9, and whether it will allow us to really do full-blown ORM.