I'm definitely in agreement about Seven of Nine, I was wary when I watched her first few episodes, but she really grew on me. She's definitely one of my favorites.
Honestly, Threshold doesn't bother me. Is it a good episode? No. But it seemed obvious to me that they were going for something and it backfired, so I don't hold it against them. It happens to the best of us. Besides, I sometimes rewatch it for a laugh so at least I'm getting something out of it, right?