The reality, Frankiespeaking, is that it does cause cognitive dissonance for any rational person. To love and to hate are polar opposites. They are diametrically distinct. Yet, any Bible reader is left to ponder how a God of love could be so harsh and vindictive as the God of the Old Testament. It is the reason that a Bible reader will say, how is it that God loved Jacob and yet hated Esau?(Romans 9:13) Didn't God know exactly what Esau was going to be when he was born? Wasn't the entire prophecy related to Jacob "usurping" his brother made known to both Isaac and Rebekah? If so, what choice did Esau have in the matter? It was all destiny, right?
This is the quandary that we are presented with in the personage of God. It conflicts with our understanding of love and hate, righteousness and injustice. It is by far one of the most perplexing of the many inconsistencies a Bible reader has to contend with.
When I was in the States recently, I saw a commercial on the tele about a candy. "Sometimes they're sour, sometimes they're sweet." I guess that pretty much sums it up.