I'm mostly following, you can convert to 120v from a 14-30 because there are two hots and a neutral, you can just choose one hot. I know that EVSEs can't detect amps, if they could this would all be much easier, but they can detect voltage? Presumably I don't quite follow this because of my crude understanding of electricity. I note that EVSEadapters.com has cool adapters for TMC Gen 1 that have no neutral and so fit 14-30, 14-50 and 14-60.
Example:
www.evseadapters.com
You're suggesting they could make a 6-30 to TT-30 adapter if they wanted, it's just that it would only be suitable for EV use, or EVSE use like the link above. Which is kinda dangerous. No matter how good your warning labels are.
Don't feel any pressure to keep explaining things to me, though it might be worth it as reference for others later.
As for PlugShare, it doesn't show campgrounds mostly. At least not on the route I use as an example. (I've driven between Atlanta, GA and Mobile, AL hundreds of times so that's my test route). I'd assumed they were not listed by choice. There may be more to it than that.