I think the OP's point when they say "do they matter" is about whether you can get by without them. Judging from the context in the comment.
But it can hardly be called a "murder mystery adventure" if the murder is solved within 6 seconds of discovering the body. In this sense, these out of combat spells are really much more about the destination than the journey.If the adventure is a murder mystery then a party of barbarians will have to work real hard, they may as well be commoners. A single 5th cleric can cast one spell and solve it as an action.
Also, and this is a tangent, I find that people often assume the game world knows exactly as much about magic as needed to make it as effective as possible. In this case, the murderer doesn't think about foiling Speak with Dead, so the spell is just assumed to solve an entire adventure in a single casting.
Probably not a bad bet to take.I'm willing to bet revivify, speak with dead, feather fall, invisibility, speak with animals are extremely useful in Curse of Strahd.
But I don't think the OP is saying these spells can't be useful.
This is a good point to make, and goes back to journey vs destination.
And if "convenient" is meant to be a bad thing, get a load of these spells that can whisk you away in the blink of an eye, and solve an entire murder mystery plot before you can say "whodunnit".
Ok so let me keep track here:
Level 1 Spells
Charm Person
Comprehend Languages
Detect Magic
Disguise Self
Feather Fall
Find Familiar
Unseen Servant
Identify
Level 2 Spells
Augury
Knock
Misty Step
Suggestion
Level 3 Spells
Clairvoyance
Fly
Speak with Dead
Water Breathing
Level 4 Spells
Dimension Door
Divination
Fabricate
Locate Creature?? Arcane Eye??
Level 5 Spells
Contact Other Plane
Passwall
Teleportation Circle
Scrying??
Where is the combat stuff? And if you remove some of these spells to get the combat stuff, does the campaign now suck because you can't deal with out of combat stuff with one of the spells you didn't grab? Many of these spells have been mentioned in this thread, so just trying to understand what these wizards look like. And remember, we're not co-DMing here and we don't want DM fiat, so don't assume you're scribing extra spells into your spellbook from scrolls and other books!