I've not played any of the modern one's but downloaded one from the PS4 Plus freebie this month.
I used to play lots of these FMV games in the arcade and at home.
In the arcade, you have to check out all the American Laser Games and Pixmanic releases. For the the home systems I enjoyed, Phantasmagoria, Ripper, Under a Killing Moon, Psychic Detective.
I did play Tesla Effect the other year (I forgot about this one when I was writing my earlier paragraph). It's really impressive and fun to play.