I think Roger Waters was always a narcissist. It reflects in his work.
If you think on that too much when you listen to their stuff it detracts from the enjoyment.
Good explainer for why the US Government spent all that money to shoot down the balloon with an AIM9X in stead of having MTG and Lauren Boebert shoot it down with their ARs or their glocks.
https://www.washingtonpost.com/nation/interactive/2023/how-us-improvised-plan-deal-with-chinese-balloon/?itid=hp_only-from-the-post_p002_f001
It always depends on the artist. Michael Jackson, people can separate the pederasty from the art because the art was so good and his upbringing was so weird.
I don't think you get to be a nazi though. That is beyond the pale (ironically).