The TV series Grimm pretty much goes in that direction, featuring a cop who finds out that he is a decendant of the Grimms, a line of guardians protecting the world from mythical creatures. The plot is inspired by tales of the Grimm brothers, not exclusively though.
Edit:
Oh, and Hoodwinked of course, a very cool animation movie! A must see!
