Murder mystery but not too graphic/“scary”

I’m new to fiction books (I like non fiction). I really liked “my husbands wife” bc it was mystery /murder/ psychological aspect but wasnt graphic or disturbing. but the ending was so ridiculous IMO SPOILER ALERT 🚨 it was a big set up and everyone knew each other already. I don’t remember the exact details [...]