Johnny, I'm guessing you haven't been to the CF forum, which would explain why you don't know about the SQL issue. It's documented and pretty easy to find over there.
CF works great for me. No real issues, my HD radio works great, my nav works (as well as can be expected for Navigator), and the plugins I need work great. I also don't have any problems with the market. I have wifi access to any hotspot, and I use connect to make my playlists so I'm not wasting gas in the car manually hunting/pecking and adding songs. I can't make playlists on my iPod without iTunes, so honestly I don't understand why people are so up in arms about making a playlist in a car.
Are you a developer of apps? So far I haven't heard any complaints from them over at the CF forum about making apps for 3.1/3.5/4.0. Bluetooth doesn't work for a lot of different front-ends, not to mention the only BT stack that works with any phone is the Bluesoleil stack, and the lack of functioning phones with it certainly isn't the fault of CF. Some people get their phones working, some don't.
My front-end choice is CF. It's fast and works for me. I enjoy using it, testing new things with it, and reporting my findings to them in the hopes I can help find bugs that can get fixed in a future release. I'm not sticking up for anybody, but if I see a post about CF (or RR, or OM, or FI) that I know isn't correct, I do my best to bring that to the poster's attention.
Although I don't find it necessary to explain anything I do to anyone on the internet, I felt it necessary in this case.