Stephanie,
MX and Apache 2.0.47... does it work? Yes, definitely. That's what I use on my development laptop.
Is it a good match? That would probably depend on who you talk to, what O/S you're running, and what you are looking to do with ColdFusion and your site in general.
If you're running a given flavor of Windows, it's sometimes just easier and more reliable to simply use IIS. Since IIS was built specifically for Windows (and some would say vice versa as well), it's a little more integrated and a little more forgiving of resources (ie - it "knows" all of Windows little nuances). By contrast, while I haven't seen the latest stats, I do believe Apache's bread-and-butter is still UNIX/LINUX and BE environments... it's where they're really concentrating. So Apache does tend to run a bit slower under Windows, though, ironically, it's often far more stable.
If you're running on <insert UNIX flavor here>, Apache is great (IMHO). It's fast, stable, and full-featured (even if it's configuration can be quite a bit more manual than something like GUI-happy IIS).
Finally, while Apache is a tremendous server (again, IMHO), it's not typically considered an enterprise-level solution. If you're looking to serve high-traffic applications with transactional functionality (read: e-commerce), you might arguably do better with more of an enterprise solution, like iPlanet, etc.
-Carl