Failed Miserably.
I was at a Barnes and Noble bookstore today. The DS could find their WiFi service with no problem, but it couldn't connect. In fact, it just froze the entire DS - where I had to reboot (oddly enough, Mr. Resetti didn't yell at me for not saving).
Anywhoo, anyone had any luck using (official) public hot spots with their DS?