The Duellists, Alien, Blade Runner, Someone to Watch Over Me, Thelma & Louise, White Squall, Gladiator, Black Hawk Down, Matchstick Men, Kingdom of Heaven, American Gangster, Body of Lies, Prometheus, The Counselor, The Martian...
...anybody who thinks that Scott is hit or miss hasn't counted his hits. I actually think that 1492: Conquest of Paradise has some of Scott's finest moments in it. It still might be the most beautifully photographed movie I've ever seen, and the Paradise themes are super relevant to Covenant. I didn't care for Robin Hood. Legend is a hot mess but it does have interesting things about it. Hannibal had some tasty moments. A Good Year is alright but not my cup of tea. Exodus was mixed but I would be very interested to see the full-length version with the missing 90 minutes. The Counselor might be the most controversial one: considered his worst, I would argue that it's his best. It has a growing cult around it, including Guillermo del Toro, who has interesting things to say about it.
In my estimation, Scott has made some of the greatest films ever made, and most of his films are above average. His worst films (Legend? Black Rain? Hannibal? Robin Hood?) are still average. I would also argue that he's getting better, since his best movie (imo, The Counselor) and his biggest hit (The Martian) were both in the last four years.
The real problem is that people like to have knee-jerk reactions to movies, and Scott's movies take a few viewings before the knee-jerk reflect wears off and you can see what he's doing. Take Blade Runner. I think Kingdom of Heaven, Prometheus, and The Counselor are particularly likely to get the Blade Runner treatment later on. It's already happening with all three. Ever since the director's cut of Kingdom of Heaven, that movie has enjoyed a pretty good revival. Prometheus has a huge following of its own. The Counselor has a smaller, but very loyal cult, and I think in the end it will be considered Scott's best film. It's like a more adult Blade Runner with the comic book elements removed.