The New Adobe ColdFusion
blogs.adobe.com
blogs.adobe.com
I've used adobe cf10, and couldn't get cfbuilder to install on a mac, so no debugger, which is just terrible. I haven't used railo because our servers were configured for us. If you're still on CF10, you're going to have to do CFML occasionally because CFScript is not feature complete with CFML. I think this was fixed with CF11.
As for their sql support, I tried the ORM and it's nothing to write home about. The CFML sql support is slightly friendlier than php's prepared statements, but php's prepared statements enable reuse where as cfml's prepared statements are more copy/paste reuse.
The whole "tags look like html" looks terrible to me and seems like a bad idea. Occasionally you have to drop into java because Coldfusion CAN'T do something. (Try parsing a date from the Twitter API).
It should totally die.