Obsidian by Rocket Science Games is a great surreal adventure game from '97. I remember playing it on family game night growing up as a kid. There's peak 90's surreal CGI, weird dream sequences with trippy transitions, impossible adventure game puzzles, the works.
https://en.wikipedia.org/wiki/Obsidian_(1997_video_game)