Is there any movie that felt like an adventure game? Many, because I switched them off!
That was in the good old days when I still had a TV.
Seriously, I don't think you can't compare apples with oranges. There hasn't been a successful mix so far.
Movies that require the use of some higher brain functions, maybe? Hmm...
* Memento
* The Sting (1973) with Robert Redford. I still haven't worked out every detail of how they did it.
Now that I think of it:
*
Tomb Raider the Movie - the anticipated suspension of disbelief, and failure to regress to the required state of teenage mind. That's what I experience with most adventure games you guys are raving about, too.