Most smartphone manufacturers (Nokia, PalmOne, Motorola, etc) opted not to implement BBConnect in the North American market, pending the legal battle between RIM and NTP over patents. That lawsuit has recently been agreed upon in the amount of $450m to NTP. With that announcement, the unseen floodgates have been fully opened and I would say to expect a flurry of BBConnect devices introduced into the consumer/business market within the next 3-6 months at the earliest (which is a realistic time period, imo). The Nokia Communicator is already equipped with BBConnect in the Japanese market, from what I've heard. You have the MDA II in Germany (you can find these on eBay). You have the Siemens butterfly phone (limited) on some continent.

So yes, its a reality. The simple reason North America (which is where I'll assume you are) has not seen it yet is the lawsuit. But hey, I'm sort of glad its been delayed... other markets have been the test markets for the largest BB market in the world.