I agree, when Ridley Scott does something nowadays all I can think about is how he will ruin it. Villeneuve is an absolutely amazing director, but my personal feelings towards Ridley Scott after Prometheus and Alien Covenant is that he should retire, his job in ruining the Alien universe is done.
Prometheus had some good pieces - I particularly enjoyed the travel to the alien world and its vistas. Arguably this is 90% special effects instead of talented directing, but worthy of my time nonetheless. The movie does fall apart when they start exploring, though...
I'll try and write some thoughts on this so maybe you can understand where I'm coming from.
I feel that a lot that makes Prometheus a good movie in itself is how it's paced and the graphical effects, albeit it still suffers from bad writing in a lot of places. The story per-se however is a complete dumpster fire because it changes and retcons the Alien universe lore to fit a story that perhaps didn't need to be told. At the same time there were deleted scenes that literally would have added 10-15 minutes to the run time and would have made it at least a 20% better Alien movie.
What makes a good movie and what makes a great sequel/prequel/movie in an established universe are two different sets of things. A good movie can be a good moviein itself but at the same time an absolutely terrible sequel/prequel/movie in an established universe. If you're working on an original idea then all bets are off, but if the work you're doing is in the exact same universe as preceding works then it needs to follow the lore of that universe - or at least NOT contradict previously established things. And you have to ask yourself - is the story that you're telling belonging in this universe? Does it enrich it? Does it bring something new? And by this you answer if the movie is worth actually making from an art point of view.
Would you like to see a modern version of the Mona Lisa painted in 3D on a computer? What if this art would have a blonde woman in it? With curly hair? And skimpy clothing? It can be a great work of art in itself, but has no business piggy backing on the Mona Lisa original.
As another example, there is a school of thought to subvert expectations by writing really dumb stuff, whereas you could subvert expectations in a manner that fits the universe. Star Wars VII, VIII, IX, Prometheus, Alien: Covenant and a lot of other works basically step all over established lore to tell submediocre stories, thus harming the universe in the process. I mean with Star Wars there's a whole 'nother can of worms - they literally made a huge part of the universe that exists non-canon. Why would you discard a lot of good stuff just so you can push your sub-mediocre stuff is beyond me, but hey, it's their IP, they do with it what they wish. I just can't be over the moon about it.