I forgot the number one reason people hate research:
Research really puts the ego on the line. The sense of self-worth of an academic, typically someone who is used to being the smartest person in the room (in any given room) is tied up with how good the research is judged to be. The idea of being judged can be almost intolerable. What if you really aren't as smart as you thought you were? What if everyone can see you're an impostor? Academia is an environment where there are a lot of smart people, so that even a smart person can end up being below average.
The judgement never ends until promotion to full professor. Even then, you can still get rejected.
I have no easy way out of the ego trap. I'll let you know when I figure this one out.