Into The Woods
I believe you are talking about the musical Into the Woods. It fits your description perfectly. Some of the fairy tales that appear in it include Little Red Riding Hood, Jack and the Beanstalk, and Rapunzel. It was written by Stephen Sondheim.
This was Walt Disney's "Mary Poppins", starring Julie Andrews.
"Canterbury Tales: A Musical" was created in 1968 by composer and playwright Martin Starkie, with lyrics by Nevill Coghill. The musical adapts Geoffrey Chaucer's classic work "The Canterbury Tales" into a lively theatrical production with songs and storytelling.
Dragon Tales - 1999 Musical Scales Hand in Hand 3-3 was released on: USA: 23 February 2005
You need to be more specific about who the "he" is that you are referring to. Many movies have been based on fairy tales.
Tom and Jerry Tales - 2006 Way Off Broadway Egg Beats Cry Uncle 1-3 was released on: USA: 7 October 2006
The 'Canterbury Tales' were set in the late 14th century, during the Middle English period.
The Alan Parsons Project
This is a song from South Pacific sung by Nellie Forbush (played by Mary Martin) the female lead. South Pacific was a 1949 Broadway musical. Music by Richard Rogers and lyrics by Oscar Hammerstein ll. The basis of the story was from a book by James Michener 'Tales of the South Pacific'. There were nine productions between 1949 and 2009 between Broadway, the London West End and films. It won awards for best musical, best author and best original score
Urban fantasy is a modern genre that often incorporates folklore elements into contemporary settings. It typically features a blend of magic, mythical creatures, and urban landscapes, creating a unique and imaginative world that draws heavily from folklore and mythology.
Mabinogion