Phantasmogoria: A Puzzle of Flesh
I never really got into Sierra Adventure Games, but I've always had a soft spot for FMV adventure games like the Tex Murphy series (although those are FMV mixed with 2.5D). The story is just bizarre enough to keep me interested and there's none of the annoying Sierra things like cheap deaths and failure states from not having the proper inventory item. That said though there aren't really much in the way of puzzles here and the FMV footage is so blocky and compressed that it looks pretty terrible, although to be fair it never really looked good, even in the 1990's. There's some pretty gratuitous violence and tits though, so it's not all bad.