On the books as only means of lore dumps, it sucks. What we should have is a nice encyclopedia system where when we find a book, it's entry is added to it. Many other games have good encyclopedia system. They can be used for other stuff too, spell entries, lore about magic items, info about monsters and npcs, etc.
