I happen to disagree. I don't think it adds excitement, but I also don't think it kills the show, necessarily. I find it very annoying in procedural crime shows, which has the cop and the non-cop specialist team up to solve crimes. (If they're the opposite sex) then it's almost a given that it's going to happen, and that's just too obvious for my liking. Don't get me wrong, I have nothing against it as such, it's just the execution which I find lacking.
As for post hooking up, it does need to be handled correctly, otherwise it just stagnates.