Now this is where I have to disagree. "Wrecked" is very much an indisputable description for what micro-gravity does. There are health problems that develop even with short stints of micro gravity (less than a month) including abnormalities in the brain that we still don't know the long term health implications of. Keep in mind that the majority of people who have been sent up there are astronauts who are by necessity at a level of physical fitness that's not representative to the local population. For the average person, they will cope even less well.

If we want to establish a long term presence in space, we want to use rotating habitats to approximate the forces gravity places on the body. For these to not nauseate the human body, they need to be fairly large which is part of why there has not been any such stations built yet (another is scientists are obviously more interested in the effects of micro gravity than of something that already exists on Earth). Rocket launches are dropping in price sharply in recent years though and space tourism is likely to grow exponentially starting this year and out (there are already more civilian launches scheduled for this year than there has been since the space age started combined).

One question which we have no idea about is what are the effects of low gravity on the human body. There have only been 24 people who have visited the moon (only half of which walked on it's surface) and none of them stayed for longer than a few days. We don't know if the Moon's gravity is more than enough or if Venus's gravity would still too little. If the program does not burn into a fiery heap from a corrupt congress and Boeing, the hope is that the Artemis program may begin answering these questions.