The network adapter will always find any "Available Wireless Networks" within range. Normally, you would select the one you wish to use and click the Connect button. When you have connected, a 'profile' is saved so that, provided you don't select the Disconnect option, the adapter will connect to the network automatically again whenever it is available.
The adapter should only connect "automatically" to networks that you've previously connected to and for which there is a 'profile'.
You can change the priority of the networks that you want to connect to and delete unwanted profiles by going into the "Network & Sharing Center", then clicking the link on the left "Manage Wireless Networks". When you click an entry to highlight it, the options to Remove, Move Up and Move Down become available.
It is unfortunate if a provider, such as your Coffee Shop, doesn't change the router's default SSID, because other routers of the same model in the area will have the same default. If you can establish which is the correct one, delete the 'profile' for the other.