Mark Drew saves the day. Check out his entry on running ColdFusion on OS X Leopard. I can definitely confirm CF works now, but I haven't yet tried the Apache integration yet.

Running ColdFusion 8 on Leopard