If that is a wizard's spellbook and they never get to meaningfully use those spells then yes, the campaign sucks. I'd put the bar at around 25%, if you don't meaningfully contribute at least 6 times with those spells then it's a bad campaign.
Where's the combat stuff? In the other PCs character sheet. Combat is only 1 of 3 pillars. And you are only 1 of 3-6 players. A wizard with that spellbook is a godsend to a party in a well written campaign.
Edit- I feel I need to stress this. It's not all or nothing, sort of. It's something or nothing. A DM who wants the players to go to another plane but doesn't make that possible will have to get comfortable with failure. But if it doesn't even matter that the cleric just so happens to have the right tuning fork, then we have a problem.