What can I say - I love referencing IMDB
Cast a Deadly Spell - Mystery/suspense/comedy - In a fantastical 40's where magic is used by everyone, a hard-boiled detective investigates the theft of a mystical tome. -
http://www.imdb.com/title/tt0101550/Constantine - Suspense/thriller/horror - Based on the DC/Vertigo comic book Hellblazer and written by Kevin Brodbin, Mark Bomback and Frank Capello, Constantine tells the story of irreverent supernatural detective John Constantine (Keanu Reeves), who has literally been to hell and back. -
http://www.imdb.com/title/tt0360486/Pan's Labyrinth or
El laberinto del fauno (yes, it's in Spanish)- War/suspense/horror - In the fascist Spain of 1944, the bookish young stepdaughter of a sadistic army officer escapes into an eerie but captivating fantasy world -
http://www.imdb.com/title/tt0457430/Although it would break alot of rules of magic and I have
no idea how you would incorporate it into a game -
The Butterfly Effect - Suspense/thiller - A young man blocks out harmful memories of significant events of his life. As he grows up, he finds a way to remember these lost memories and a supernatural way to alter his life. -
http://www.imdb.com/title/tt0289879/An interesting version of what could be an extended soul gaze -
The Cell - horror/suspense/psycho thriller - A psychotherapist journeys inside a comatose serial killer in the hopes of saving his latest victim.- good visuals/disturbing -
http://www.imdb.com/title/tt0209958/Pretty much anything with superheroes could be modified for the supernatural as well