David Lynch The Grandmother would be considered a "masterpiece" by this definition.
https://www.youtube.com/watch?v=4y0rYWVcxF4
Anyone could make something along those lines right now with AI tools. The ratings is because of what the fame David Lynch achieved after making this.
AI video is going to stall bad because it is just too expensive and what we have now is complete trash. Sora is such a massive disappointment to anyone who was interested in doing exactly what is being described.