I don't think that any character got shittier writing than her, with the exception of maybe Yar's death, and even then I think you still have to give it to Troi because she's got many more episodes. But her episodes are the ones that are the most consistently bad. Data's are mostly great, Worf's also pretty solid, Geordi has some stinkers mostly because the only thing they could figure out to do with him is have him lust after an unavailable woman, Crusher only has a few that are hers and honorable mention for one of my bottom five TNG eps of all time, Sub Rosa, but Troi's are pretty much all stinkers. The only one that I can think of off of the top of my head that I like is the one where she decides to take the command test.

Troi counselling with her powers: Suck it up lean to live without.

Troi counselling without her powers: I don't know just get better or whatever... I'm a failure!

Her mom is an ambassador. Some things never change.

To be fair, stating the obvious, which she does quite a lot, is also quite advantageous. Like, sure, that Klingon Captain seems angry and insulted, but what if he's just a really good actor trying to deceive a Federation ship? When Troi goes "Yup, he's angry and insulted" that would basically be the go ahead to assume he's telling the truth and act accordingly.

But TNG writers usually only seemed to remember there was an empath on the bridge at the last second, so they just wrote in she can't sense anything

And that the alien who is yelling seems angry

Show was written in a time before streaming, before people could record TV. She was there to explain to the audience, who were assumed to not be aware of the previous episodes, who the bad guys are.

Well, they're all basically locked in a submarine, but way worse. You're in a sealed box hurtling through space. You need a doctor on board, and you need a counselor on board. If you don't want both of them to go completely insane, both of them also need friends and social interaction.

While I agree that Starfleet levels of general fraternization are a lot looser than in modern military, I also think it's just kind of something you learn to live with when you serve on a ship.