I think part of Cloud's hatred was that Sephiroth was a false idol. He felt betrayed, and realized Sephiroth obviously didn't deserve his idol worship. I don't think he felt both hate and respect. I think he felt hate, and a deep loss of respect. But yes. I can imagine it. Happens all the time in real life. Idols aren't special. They're just people. We give them weight with our views. And like people, they make mistakes. Heroes can disappoint. I have a thing for it when its written into fiction. Helps with characterization and growth so that people aren't so two-dimensional