Which strikes me as broadly what SNW has,
True!
Picard: In love with best friend's wife, best friend dies under his command, ship gets destroyed and then his girlfriend betrays him at the court-martial
Riker: Mother dead, estranged father
LaForge: Fine
Data: Creator disappeared and colony destroyed, evil twin tries to kill him multiple times
Worf: Parents killed and colony destroyed, raised by Humans, torn between the Federation and Klingon Empire
Yar: Parents abandoned her, grew up on planet with no government, subjected to sexual violence from street gangs
Troi: Father dead, later we learn of a secret dead sister
Beverly and Wesley: Husband/father died under Picard's command
Lots of tragedy in the TNG backstory even before PIC's revelations about Picard's early life!
Tragedy seems to be the norm for lots of characters in Trek.
TOS/Kelvin
Kirk (prime): One of the few survivors of the Tarsus IV disaster
Kirk (Kelvin): Dad sacrifices himself during an attack by a time travelling Romulan mining ship to let his family and crew get away to safety
McCoy: Divorced
Scotty: Fine; is initially killed by Nomad but revived, and later loses nephew
Chekov: Fine
Sulu: Fine
DS9
Ben & Jake Sisko: Lost wife/mother in the Battle of Wolf 359
Kira: Fought against the Cardassian Occupation as a part of the Bajoran Resistance
Odo: Not recognized as a sentient being and experimented on; held guilt for actions as chief of security during the Cardassian Occupation
O’Brien: borderline racism towards Cardassians for forcing him to kill one of them; had never killed before prior to that
Bashir: had learning disabilities as a child; was genetically enhanced despite breaking Federation law
Quark: End up disgraced, fired and broke for banging the boss’s sister
Jadzia: initially rejected for the symbiont program and is haunted by it
Ezri: is the new host of the Dax symbiont after Jadzia is murdered by Gul Dukat; is unprepared for the role
VOY
Janeway: Father drowned, later finds out her fiancé has moved on after being stranded in the Delta Quadrant for years
Chakotay: Dad killed fighting the Cardassians, resulting in joining the Maquis to fight them
B’Elanna: felt alienated for being half-Klingon, dad walked out when she was five, dropped out of Starfleet Academy
Paris: Dishonorably discharged from Starfleet over a fatal training exercise, served time in a penal settlement
Tuvok: resigned from Starfleet due to experience with humans on the Excelsior and stays away from Starfleet for half a century because of it
Kim: Fine
Seven: Assimilated when she was a child along with her parents
Neelix: entire family killed and homeworld destroyed in a war
Kes: Dad dies when she’s one, is captured and tortured by the Kazon
The Doctor: Fine
ENT
Archer: Father dies when he was 12
Trip: Sister killed in unprovoked attack by the Xindi
T’Pol: Had memory wiped after assignment to capture rogue agent; later on is victim of mind meld rape and develops a trellium-D addiction
Reed: Grandfather killed by mine left over from some world war; recruitment by Section 31 at a young age eventually leads to betraying Archer's trust
Phlox: Estranged relationship with one of his sons
Mayweather: Grew up on a cargo ship evading pirate hijackings, loses father while far from home
Sato: Expelled from Starfleet for breaking someone’s arm over a poker game
The tragic backstories of the SNW characters are in line with Trek history.