
It already came up in the comments section of a previous post, but I really ought to give another mention to
Once Upon a Crime, an old-school point-and-click adventure by Bjorn "Ghost" Ludwig (and thanks again to SSH for pointing this game out to me). In
OUaC you play as newly-licenced Private Investigator Little Red Riding Hood who is called upon to solve the recent murder of the Big Bad Wolf (although surely she'd be considered an obvious suspect, no?).
The game is reasonably short (a couple of hours of gameplay, maybe) but has some colourful and charming character designs and a lot of humour, as well as (although I don't want to give too much away) a pretty neat post-modern twist towards the end, which I enjoyed immensely.
OUaC is
free to download. Personally, I found a couple of the puzzles a little frustrating, but luckily,
there is a guide available.
Incidentally, and this is in no way a slight against
OUaC, the fairytale-character-turned-private-investigator subgenre
sure is popular,
no?