In terms of what I would call "light and frothy" mysteries but I guess the book term is cozy??, I like the Magical Cats books by Sofie Kelly. A librarian whose life changes when she moves to a small town in Minnesota and adopts two special cats.
In many ways similar, a big city gal moves to rural Minnesota are the Needlecraft Mysteries by Monica Ferris.
https://www.bookseries.org/authors/monica-ferris/
Mostly because they are set in this general area, I get a bit of a hoot from Mary Daheim's Bed and Breakfast series, I picked up one at random and I don't think it really matters if you start from the beginning or not. Two (older) cousins, one with a bed and breakfast and the other a bit more cranky... I understand from reading review sites that you either "get" them or you don't and a lot of people just don't like them. I can see that.
edit: oh! oh! I forgot to put in the books I actually meant to put in, on the light and frothy sort of mystery but add in some historical stuff, that means the Amelia Peabody books by Egyptologist Elizabeth Peters.
https://en.wikipedia.org/wiki/Amelia_Peabody_series