This is a great watch for those who're already a tad familiar with Fate/Stay Night. As a standalone it's a bit lacking in context, but either way it'll still be a good watch. It's a simplified version of a much longer story, but it's pretty tastefully done and the directing is fantastic. The dialogue is also noticeably better then the TV counterpart (which was extremely hit-or-miss at times), while still certainly being cheesy. But Fate/Stay Night is mostly dumb fun with maybe a bit of emotional investment for some. It's not exactly the most intense of Battle Royale story-lines, but you gotta give Kenji Kawaii (the man behind the music) heavy credits for giving the Deen series a truly unique feel for the Fate universe that was never again matched. While other Fate stories may be more in-depth with plot and characters, I think this movie has the best overall package for those Fate vibes. It's a shame they didn't make a whole anime of this quality back then. And I should note I watched this way back when it was a thing, just gave it a rewatch and still like it (while TV counterpart not so much).
If you're going to step into the Fate universe with this though, definitely watch the first 3 episodes of the original Fate/Stay Night anime first. They brush over that part in particular which hurts it a bit.