I have yet to see the adaptation, but just finished reading the books a few months ago (in my 40s), and while I liked them they did not (to me) live up to the hype.
I can totally see that they would have stood out more as something new in the 80's. Going back and reading some of my favourite comics from the 80's is bittersweet - seminal stories like the X-Men Dark Phoenix saga or Days of Future Past are marred by extremely annoying and intrusive exposition (I like exposition in books, and when well done it's great in comics too, but 1980's Marvel and DC exposition was so in your face most of the time), and Sandman work much better today than they do (other examples that stands out in retrospect in that way is Watchmen and Alan Moore's Swamp Thing run).
But unlike, e.g. Alan Moore's Swamp Thing run which still stands out to me as outstanding by modern standards too, while I can see many things that'd make it stand out in the 1980's, and while it's still quirky, it didn't quite reach that level to me (admittedly, it's an extremely high bar, so to reiterate: I did like Sandman).
I can absolutely see myself having a very different view of it if I read it back then, though. Put another way: If I came to X-Men's Dark Phoenix or Days of Future Past story lines today because someone raved about it, and I wasn't used to the comics of the era, I'd have a very hard time seeing past the veneer of heavy-handed story-telling, but I remember them, and so I find it a lot easier to see through how dated they are, even though their execution is worse by modern standards.