I think part of this situation has to do with the fact that we human beings generally develop routines and patterns to our lives. We have all taken road trips in ICE before. We have a schedule for arrival, and we have a schedule for departure. Our routines may be tailored differently when we travel solo versus traveling with family. Regardless, now that we are driving Teslas, we ought to rethink our routines a little bit if we are staying at hotels with Superchargers and/or destination chargers.
I fall into the camp that we should not park overnight at a SC if at all possible. If that means splitting my charge in two (arrival to 90%, move car, plug in for 100% in the AM) so be it. If it means rising 30 minutes early and plugging in at 6:30 for an 8:00 departure, fine. Moreover, I think that we are setting a standard or a precedent. Others see me plugging in overnight, so they join me.
(As a parenthesis, I stayed at the Best Western in Mt. Shasta last summer. That location has a 4-stall SC. I counted five (!) Teslas in the parking lot. Not one person to my knowledge charged overnight. The SC was vacant at 10:30 PM when I walked back from downtown. The following morning, I plugged in at 6:30, and there was one other owner charging. When I departed at 7:45, the first guy had left, and two others had plugged in.)
I think the implied contract of Supercharging has always been to charge what you need to reach your next stop, and then move your vehicle. It makes no difference whether the charging is diurnal or nocturnal.
When the time comes, and there are scores of EV charging stations in parking lots across the country, we can revert to our prior habits. Until that day, I think we need to adjust our behavior and thinking to be courteous to others.