The way I see it, you need Superchargers at two places. A.) along interstates for long trips. And B.) at places that attract relatively large crowds (and by people from far distances) (e.g. amusement parks, stadiums, parks, monuments, downtown of major cities).
The reason you need B.) is for the simple fact that you'll already be spending a lot of time with your car parked at this attraction. Imagine you drive near the range limit of your Model S with your family to a park in the morning. You spend several hours during the day there, only to have to spend another 45 minutes charging the car after you start to head home. Even if that Supercharger is just 10 miles away from the park along an interstate, you still are faced with two choices. Either spend the 45 minutes charging prior to arriving at the park, or spend the 45 minutes after. This is unfortunate considering how this could have been avoided had there been a charger at the actual attraction.