I appreciate the note of caution and believe me, I'm painfully aware of my current weakness. I spent about three days immersed in reading and you tubing this. Most of what you see is kind of (prior to really looking deeper) is pretty gonzo stuff, promoting more of an end point.
When I looked into the business model I figured out that instead of signing up people in bulk and hoping they never actually show up because folks overlook low payments; they actually have a really vested interest in making sure that you a)stay motivated and keep justifying the money, b)get measurable results, and c)don't get injured (and stop coming/paying)
They have a lot of ways to scale the workouts and won't let you get going without knowing what you're doing. There are no unsupervised workouts, the coaches don't stand in the front of the room and demo, classes are limited to 15 with 2 roaming coaches to check/correct everyone all the time. The two places on my finalist list are:
Place A
Pretty close
Have a "ramp up" period for training basic techniques
You have to demonstrate 7 fundamental skills before getting out of "fundamentals" class and joining gen-pop
Then you do standard WOD while supervised at your own level
The intensity is baked in and always scales (something I like)
Place B
Much further away
Has a one month basic class 3x per week before you join gen-pop
Also offers a "masters" class (old farts like me)
Same last two things
I watched a fun 12 part YT series called
Killing the Fat Man that chronicled a 40yo heavy guy getting into it over three months and then some of his 68yo dad who'd just had heart surgery too. It was interesting.
I know I'll have to start super slow, hell, I could only do half my river walk this morning and I'm wasted, but I want to learn the right way. Otherwise I'll learn it "my" way and then have to start over the right way.
I get that there has been in the last 7-9 years a move to make it a commercialized sport, more power to 'em, but that's not what I'm after. I want a workout that will be intense, adaptive, efficient, and build real-world capabilities. That it is done with minimal equipment using compound movements, resistance and interval training, and peer encouragement all looks good to me. At least until I'm the one panting on the floor.

Which will be my first visit.
I have generally been a bit too gung-ho myself and know what you're talking about, I'm hoping age will bring a little humility this time!
It will probably be a couple of days until I can set up initial visits, I just got a project dumped on me, but rest assured the gory details will be here.
