I had the same experience with Scott Card. I loved the Ender books, the books about his older brother trying to be a good person when he was a “bad child” really resonated with me.
I was so disappointed when I looked him up and saw how hateful he really was.