Don't Look Now - I own this and always thought it was...pretty good, but never quite great. I do not agree that the ending is weak, though it's admittedly slightly telegraphed. There's a Criterion of it, though as far as Roeg movies go I vastly prefer Walkabout.
Hereditary - Stylistically this is very impressive and shows that the director is a hungry young new talent....but on a storyline level, well, it just ends up being another truckload of "whatever crazy things we need to have happen in the movie will happen, and somebody else can explain why and how." Also has one of the more disgusting images I can think of in recent movie history. I do not at all recommend the bloated, overlong, miserable followup Midsommar, from the same director.
Scream - Are you trolling me...well, it doesn't matter if you are, I do still love this movie, but it's probably going to have a diminished impact if you watch it for the first time at age 40. I still think the big set pieces that open and close the film are masterfully directed on Craven's part, if we must discuss the film on an "adult" level.
You can skip most of the sequels if you want, though the most recent two have some positive aspects to speak of.
Doctor Sleep - Not recommending this. I actually rather liked the book, even if like all King books it could have used some trimming. The movie gets caught up in nostalgia p*rn/fan service regarding the Kubrick movie, with the main character revisiting the Overlook Hotel and various actors brought in to play characters from the Kubrick movie and shots and lighting and such ripped off wholesale. That aspect of the movie is an epic fail (and of course for obvious reasons it's not in King's book.) The one thing that saves the movie, if at all, is that Rebecca Ferguson was really good as Rose The Hat, the villain.
I keep forgetting to watch Last Year At Marienbad.