The best FMV game, in my opinion of course, is Dracula Unleashed. It is handled extremely well and feels quite close to a point and click adventure game. The rest unfortunately, at least from the 90's, are not that great of games and worth it only really for collecting and nostalgia.

There are many newer FMV games that are awesome and well done, most are on Steam. They still hit the barrier of FMV games though - lack of replay value and too linear for most fans to enjoy.