That guy had at least three magic systems going at once. It was a lot.
There was sympathy, which was kind of like voodoo dolls and also sometimes casting from hit points? Sygildry or something which was programming with magic runes. And Naming, which I believe was like grokking something so well you could just command it to do whatever.
Aside from the more well-known greats people have already mentioned, I have to nominate Herc's Adventures and MediEvil 1 and 2.
How we haven't seen a new MediEvil game in the age of souls likes baffles me. Souls combat with Dan's goofy comedy in an open, interconnected Gallowmere? Please take my money.
I also wouldn't mind seeing a new game in that style LucasArts used for Herc, Zombies Ate My Neighbors, and Ghoul patrol. But with them under the mouse, it's probably as likely as another Monkey Island.
If you want to be super pedantic (and I do), time travel may not be necessary for the stormtroopers to work.
Star Wars is a long time ago (as of 1977), in a galaxy far away. A ship full of stormtroopers could have come through a wormhole to medieval Earth. Or depending on how long ago Star Wars is, could even have been cryogenically frozen, drifting towards Earth for ages.
I like fiction podcasts, and the main one I'm working through currently is The Magnus Archives. Each episode is a short first-person paranormal horror story, and they start out pretty standalone, eventually building more background and connections between the stories and adding more "frame story" about the people collecting these tales. I wouldn't say it's an SCP clone, but it's kind of shaped similarly.
Kathy Bates is a national treasure and doesn't deserve that comparison.