Even with that and the limited range, I bought the right car for our usage pattern and have been overall extremely happy with the car. It's been relatively trouble-free (one visit to the dealer for some combined warranty work on the battery, Takata air bag recall, and some other recall or other, all of which were taken care of for $0 and included a free loaner car while it was being done), otherwise requiring two sets of wiper blades, some washer fluid, and one tire to have a nail hole plugged.
When I say we bought the right car for our usage pattern, we paid around $21K (net of government credits) for a car that will still do 75 miles on a charge. Before COVID, my commute was 16 miles round-trip and had chargers at work. After working remotely, I drive the car much less and our two-driver family has a traditional ICE car for any longer trips. We both prefer the LEAF for around-town errands and it gets more drives than the ICE car does. I think once in 7.5 years we had a conflict where we both had more than 100 miles to drive in a day and I worked it out by charging the LEAF during my day. It's been a non-issue and getting a car that's given us >7.5 years of drama-free service for $21K has been great.
According to the US DOE, we have 4450 CHAdeMO stations and 4583 CCS stations in the US at the moment. No major charging network has started building CCS-only stations yet, though EA plans to in the future. I don't see why you're feeling that remorse, your charging network is large and continues to grow, despite your car being discontinued in the next 2-3 years.
I've owned two Nissan LEAFs (2012, 2018). The things that would give me buyers' remorse are faults of the car, not anything external. Like, not charging any faster than 40-50 kW, charging at half that speed once the battery gets hot, losing 10% of its range to battery degradation after just 3 years, and offering no upgrade path to keep the connectivity features working after AT&T shut down its 2G then 3G networks.
I drive a VW ID.4 now.
Yeah, that's a bit annoying. In the US, many(most) still do, but there aren't going to be many (if any) new CHAdeMO installations. Even more so now that Nissan itself dropped CHAdeMO in the US. The Ariya will be CCS.
That said, if you are in a city, L2 should continue to expand and hopefully you'll be able to top off during your normal activities.
The charging situation for electric cars for road trips is still a thing... It seems to have found a standard in CSS. I expected there to be adapters, but apparently making adapters is slightly non trivial as there is a lot of chatting between the car and charger.
I know a Bolt owner though, and they seem pleased.
I also know someone that has a Fusion plug-in hybrid. He loves it.
I have seen the F-150 Lightnings around, but don't know anyone that got one (yet).