Picard was such a mess

the first season was a lot of build up to a meh ending, the second was filled with headscratchers (and sudden musical numbers and juice that makes you burp across time and space)

Then the third season felt like they just gave up and said 'Forget the rest of the show, here's that 40 year TNG reunion you damn nerds want'

They kinda set up the other side of it in I, Borg, with how lonely it is away from the collective.

It's the ultimate comfort, at the cost of ultimate conformism. You are never alone. You face all your thoughts, feelings, fears, problems together with countless others with no shame or social anxiety.

Consent play, sub dynamics, emotional discomfort, physical suffering? Hol.hold on, I can, I can only get s.so, I can only get so hard

That sounds like a job for Miles O'Brien.