There are sooo many great books that are fairy tale retellings (or fairy tale inspired)! I've read a LOT of them over the years and I've determined that the genre has something for everyone! I'm going to share my top favorites, but it is worth noting that I am absolutely prejudice towards authors who either 1) include humor in their stories or 2) use beautiful language. (I thought I should own up to this ahead of time because the pattern is going to be pretty dang obvious early on.)
If you prefer to only read retellings of your favorite fairy tale (I don't blame you!) I have separate blog posts for most of the most popular stories:

Note: I'm only including books in this list that have no spice and very low language. These would probably be considered clean or closed door fairy tale retellings by most readers.
My Top Favorite Fairy Tale Adaptations:
Best Cinderella: Ella Enchanted by Gail Carson Lavine Gail does a lot of fairy tale-esque books, and while I enjoy them all Ella Enchanted is by far my favorite. Elle is an awesome heroine, and her story will both break your heart and make you laugh, plus the world building is some of the best I’ve seen.
Best Beauty and the Beast: Beauty by Robin McKinley “Chalice” and “The Blue Sword” are probably my favorite of Robin’s books, but Beauty is right up there with them. It has Robin’s typical/gorgeous descriptions, and it–probably more so than any of the other books I’ve listed–has more of the beautiful-true-blue-fairy-tale feeling to it. (It’s the perfect story to curl up with on a rainy or snowy day.)
Best Goose Girl: Goose Girl by Shannon Hale This book is why I will not include a retelling of the Goose Girl fairy tale as part of my Timeless Fairy Tales Series. It’s too perfect and too wonderful, I just can’t! If you haven’t read it yet…what are you waiting for!?! Reeeeaaaad!
Bonus: Goose Chase by Patrice Kindl This story is a mix of several fairy tales including Goose Girl, Wild Swans, and Diamonds and Toads. This book is definitely a children's book but it is so much fun and really deserves a read. The main character is a hoot–I love her sarcastic and down-to-earth personality that shines through no matter her circumstances.
Best 12 Dancing Princesses: The Princess Curse by Merrie Haskel This book is by far the most original twist on the 12 Dancing Princesses story I’ve ever seen. It has a lot of humor in it, but it also digs deep into the story’s characters and examines what makes them tick. Merrie has a couple of other great fairy tale retellings–though Princess Curse is my favorite–so if you haven’t heard of her I highly recommend you give her a try!
Best Tam Lin retelling: The Perilous Guard by Elizabeth Marie Pope So this story technically isn’t a pure retelling of Tam Lin, but it’s still amazing…again because the main character is kick-butt and there’s several incredibly funny lines in the story. Please read it, because then we can laugh over the last few pages together–the best lines are in that part.
Best King Arthur retelling: Avalon High by Meg Cabot So technically this isn’t a fairy tale, but who is splitting hairs? If you enjoy humor, then this modern rendition of King Arthur is all for you. It’s one of the few King Arthur stories that actually has a happy ending!
Best Original Fairy Tale: Howl’s Moving Castle by Diana Wynne Jones Seriously, this story makes it on my top ten favorite books of all time, it’s that good. It’s adorable and fun, filled with lots of adventure and romance. AKA EVERYTHING I LOVE! It has a lot of common fairy tale elements–a transformation, magic battles, riddles, a self-centered wizard, and more–so even though it’s not based on a fairy tale per say, it would be right at home in Cinderella’s Kingdom or in Beast’s country.
Best Fairy Tale-esque author: Vivan Vande Velde About 75% of Vivian’s work all has a fairy tale flavor to it–from Dragon’s Bait to Heir Apparent–and she’s an amazing writer. If you haven’t heard of her you are in for a real treat. She and Diana Wynne Jones are my literary heroes (along with Jane Austen, that is) so if I’m coming off as a fangirl…it’s because I am.
So….who–or what–did I forget? I know right off the bat I didn't list a favorite Sleeping Beauty retelling, but I haven’t really read one that has made me fall-head-over-heels-oh-my-goodness-I-forgot-to-eat-in-love yet.