I just requested a book with 795 holds on it (there are only 38 copies). The book is The Girl with the Dragon Tattoo. We'll see if it lives up to the hype.
One book that was *not* worth the hype for me was Water for Elephants. Everyone recommended this book to me - bloggers, MIL, Pilates teacher. I took it out of the library three times and could not get interested.
One book that *was* worth the hype, a few years back, was Michael Chabon's Amazing Adventures of Kavalier and Clay. I'm waiting to see if The Guernsey Literary and Potato Peel Society will be worth it.
What's your experience with hyped books?