@Krugerrand - sounds like you are already living the experience that I dream about for the future! Unfortunately, my experience with destination charging on my travels has been very hit-or-miss, even where I would have expected better:Why needing SuperChargers? We stay at hotels with L2 Tesla and other chargers and our car is always full when we wake up in the morning even if we arrive late, with low mileage left, and leave way before checkout time.
Maybe we just have a horseshoe up our butts, but we’ve never had an issue of not working or not being able to charge. Of course, we always have a plan B just in case.
* Westin La Paloma in Tucson is an amazing property, one of my favorites, highly recommended, but they only have 2 Tesla Wall Connectors for a very large property. Years ago I had a 3-in-4 chance of plugging into one of them overnight, before Teslas became commonplace; in recent trips they have both been in use the entire time I was there. Fortunately, once Tesla opened a Supercharger at the nearby La Encantada that has become the default fallback.
* Monterey Marriott is our family's go-to when stopping in to visit the Monterey Bay Aquarium, and has many destination chargers in the underground parking garage that valet parking handles. Last month during a 2-night stay there, they were able to charge my car, but the prior 1-night stay they simply had too many cars in the queue and mine didn't make it before we headed out the next morning (found a nice Supercharger with a Starbucks that morning and had breakfast there while charging instead of having breakfast at the hotel that trip).
* Paris and Aria resorts on the Las Vegas strip are both great properties to stay at, with EV charging (ChargePoint) in their parking garages. I've stayed at both with exactly a 0% success rate at each despite multiple stays / multiple charging attempts; chargers are too few for the cars parking there and often one or more stalls are not working. Fortunately, the Tesla Supercharger on the strip has both Superchargers and Wall Connectors (my default choice if one of these is open is to charge at a WC slowly, but sometimes even these are filled up and I just plug into one of the SC stalls).
The list goes on, but sufficeth to say, to-date destination charging has been a mixed bag of experiences for me and my typical trips. There have been some consistently good experiences as well (TY to Paradise Point in San Diego for expanding your charging stalls, and there was a small B&B in northern AZ which has a very appreciated Tesla Wall Connector), so that future can and will happen. In the meantime, when my wife and I were just planning our next trip (coastal CA), we narrowed it down to 2 nice properties, called each and learned neither had on-site destination charging (really??? In CA?!?!?!). We nearly went back to looking at other hotel options before seeing that one of them was actually a mile or so from a Supercharger and deciding that would have to be good enough.
TLDR: Anecdotally, my data-point-of-one-person is that on my travels, 3rd party chargers are most common but are very unreliable; Tesla Wall Connectors at hotels are less common and while they are working far more of the time, the 'free electricity' motivates properties to have too few of them; hence predominantly ending up staying at properties that have Superchargers on-site or immediately nearby. Even when we start with other goals ("Let's just plan the most relaxing beach stay", ultimately high confidence charging ends up being the most critical feature of a hotel, and that's usually SCs for the trips I end up on.