It get’s a lot of hate, especially from armchair critics. I’m an armchair critic myself, but I truthfully do not understand the hate. Everytime I rewatch Rogue One, I try to find reasons to hate it, but it’s pretty watchable if you ask me. People hate Jin and complain that her character and motivations make no sense, but I disagree. Her decisions are logically consistent with what she learns about her father as the movie progresses.
Anyway, I enjoy it every time I watch it, which is far more than I can say for the vast majority of Star Wars movies and shows produced in the 21st century.
It’s weird, because I loved Spirited Away upon first watching it. But I can’t do it anymore. It’s like you say, a dream with no consistency. I let it fool me once, but now I’m lucid and see through the facade.
That’s not to say I think it’s bad, per se. It’s still beautiful, and fascinating, and has a great score… But for me personally it has no re-watchability for precisely the reasons you mention.