Yaarel
🇮🇱 🇺🇦 He-Mage
A consequence that you may not have thought about here is the effect of being able to use these spells on NPCs. It's a lot more difficult to run a "murder mystery" style adventure when you can just resurrect the victim and ask what happened.
Yes, there's speak with dead, but (1) that spell has limitations on it while questioning a resurrected NPC has none, and (2) you could easily have a party where no one took speak with dead but there's virtually no way you'll have a party without revivify under your new guidelines.
Generally speaking.
I am less a fan of sabotaging character concepts for the sake of making a dungeon crawl secretive.
For example, D&D mostly destroys the classic ability of being able to Phase thru solid objects, delaying it to ridiculously high levels, just so the DM can keep a room secret.
In the case of Phase, I would rather low level be normal. When the DM needs a room to shut out player characters, then there needs to be low level spells like ‘Wall of Protection against Evil’ that also shut out phasing characters, thus can seal off a room.
Regarding murder mysteries. I find them almost untenable in D&D. Even a low level nonplayer character can hire someone to cast Raise Dead. The murder no longer has serious consequences.
In a magical world of resurrection, prescience, scrying, and contacting souls elsewhere. A murder mystery in D&D would need to be ingenious to even remotely feel believable.
Part of the solution is spells like Nondetection to block attempts to identify the murder.
The success of a murderer depends on contests between powerful mages.