I have two from one 'story,' Jake and Ben Sisko, from Deep Space 9.
Jake could almost be forgiven, as his out of placeness isn't really his fault, but merely a side effect of the direction they choose to go with the show, which didn't have much room for him. But he's so absolutely frustrating to watch that I take back my forgiveness and replace it with a thrown brick. After the first season or so, Jake serves as nothing but a poster boy for how entitlement, particularly that of the 'Utopia Dwelling' humans, is based entirely on bullshit. He's arrogant but completely helpless; supposedly 'more advanced' then lesser races yet entirely dependent on them for even the most simple task; He supposedly wants to walk his own path, but can't go 5 minutes without leeching off of his father's position and reputation, or his friends more grounded and hard earned resources. He's basically what people claim the 'modern millennial' is, only times a billion and with crap fashion sense.
And worst of all, Jake is the only person in the entire Star Trek universe to make Ferengi values (Ultra-Strawman Capitalism) seems entirely reasonable. Not just a specific tiny bit of it - The whole damn thing.
I don't hate Benjamin Sisko quite as much, but I'm still not fond of him. The writers, in my opinion, would often go way, way too far in an attempt to distinguish him from the other captains, all the while continually piling more and more Gary Sue qualities onto him. I found his persistent 'badass' reputation and actions over blown, having the main character of a Star Trek series be a religious icon and predestined fixer upper was, in my opinion, a misstep, and unlike Picard, who remained in the background a lot of the time, and who's entrance to the forefront was something you looked forward to, Sisko was up front for the majority of the series, and the best episodes were, by far, the ones where he was forced into the background and the more interesting side characters got the spot light.
That being said, I suppose he wasn't completely terrible. He does have some good episodes, and his interactions with several characters (Dukat and Garak) was entertaining, but sometimes I feel like that was despite of his character, as opposed to because of the character.
Oh, and for fucks sake, I get it, your from the swamp. It got brought up more frequently and frustratingly then Picard's french connection.