They are all basically the same thing from the iPad (or laptop) user's point of view. They are all Wi Fi connections, the difference being how they connect to the data.
I'm glad places that offered paid hotspots are finally having to cave and offer them for free now that so many places are offering free Wi Fi. Heck, it doesn't cost much of anything to offer Wi Fi, so its silly to try and make people pay for it.