Absolutely, but only on Musk's Crew Dragon. Branson and Bezos seem a little too loopy about it. I can see them easily having a major incident. The Russias as well. If you read through the Soyuz missions, there have been a ton of close calls undocking, and five or so 7g ballistic reentries. Sorry but I have no interest in getting crushed to menehune size, then having to audition for a Wizard of Oz Remake.
Is this like a ride along with the police, only with astronauts ? I'm down for it, just as long as we get back before I have to use the restroom or have to eat a meal. The challenges of both of those wouldn't be worth the experience. But the rush from leaving the planet & returning has gotta be better than the rides at Disney or a commercial flight.