Whoa! Good catch. That timeline almost lines up exactly and it’s very possible that O’Brien was referring to Una. It could also be that O’Brien is indicating that sentiments have maybe changed somewhat in 100 years, something that we are lead to expect from SNW. And indeed Bashir is allowed to stay in Starfleet without even having to find a technical loophole and Richard’s punishment is considered harsh at 2 years. Given the future utopia that we’re dealing with and the historical significance of the crime I think what we’re seeing is that no one really does this anymore and so it’s not really an issue.
I really hate that Prodigy was unrewened because a courtroom episode of Prodigy where Dal gets the right to serve in Starfleet and the Starfleet ban on genetic augments is lifted would be a pretty cool.
I suspect this isn’t covered for a variety of reasons, but what we do see shows an Earth steeped in nostalgia blending with technology that alleviates the overwhelming majority of material concerns. No one needs to worry about food, shelter, clothing, or profit. They work to better themselves for its own sake and they relax and stuff.
I think the message is that Earth is boring and humans, having created paradise, left it for knowledge of the stars. Civilian life is coffee and breakfast in the morning before dropping the kids off at school, plenty of time to pursue niche hobbies, and probably also time to pursue some career interest and education.
However, you raise an interesting point in that civilians from the perspective of Starfleet officers are even more out there. These are folks who often wanted to go even further than the rest of society wanted to go. Fringe people with eccentricities to un civilized to stay within the Federation. The intersection of these two kinds of civilians is what I would like to explore.
A happy family who have lived in paradise are suddenly Swiss Family Robinson or Lost in Space style thrust into deep space and must survive without the comforts of paradise would be an interesting way to tell the story of what it’s like to be a civilian in the Federation.