Also you know he's just like that cus the writers wanted a dramatic scene with some tension.

This highlights my main issue with DS9.. DS9 had a big budget and they hired the most expensive / "best" TV writers. The problem is all those fancy TV writers were drama writers and not sc-fi nerds.

DS9 is probably a better written show then TNG but its more of a drama / soap opera than a star trek show.

Especially considering that the point of his wife dying in the Big Bad Beetle Borg Battle thanks to Possessed Picard is never, ever relevant again. His wife could have died in any other manner, or simply separated, and it wouldn't have affected a thing about his struggling single father background.

They just wanted some clumsy drama bomb to tie the very first (and risky) Star Trek spinoff show to the main series.

My issue with DS9 is, no matter how well the story was written, I couldn't stand ANY of the starfleet characters.

It had better characters, better long plot arcs (because of a change in TV series styles at the time, not specific to DS9), better effects, but the melodrama is at times unbearable. I'd rather have cheesy technobabble BS with the Enterprise flying away at the end with no consequences than some stupid shit where someone is jealous of a new boyfriend or whatever.

The writers that gave us O'Brien & Keiko's marital strife...

I wanted Cisco and Picard to have an adventure together, so that Cisco would forgive Picard and they could be buddies.

I heard Cisco is showing up in Picard S3. Too bad there's no way to ever know if that's true.