I'd recommend A Little Commonwealth by John Demos. It is a bit older scholarship than the book /u/textandtrowel recommended, although it was updated for the second edition which was contemporary to The Times of Their Lives. Also, the scope of A Little Commonwealth is a bit narrower, focusing on family life in Plymouth colony for the first two generations.

Yup! and it's called The Times of Their Lives: Life, Love, and Death in Plymouth Colony by James Deetz and Patricia E. Scott Deetz. James Deetz made his name excavating at Plymouth and played a key role in shaping historical archaeology in the US. This book is perhaps more text-based than some of his other works, but it retains an archaeologist's love for trying to understand the everyday lives of people.

There's lots of other great books out there that touch on this time and place in different ways. Two you might also want to check out are The Unredeemed Captive and Mohawk Saint. They don't fit what your asking for, but they help build context around it and are terrific reads to boot!

A good one for philosophies on life and superstitious religion is David D. Hall's Worlds of Wonder, Days of Judgment: Popular Religious Belief in Early New England. It won't give you as much on day to day life as the Deetz book mentioned above by texandtrowel, but it will dive into their belief systems quite a bit.

I would half recommend Edmund Morgan's The Puritan Dilemma and one of the most important works in the field, Perry Miller's The New England Mind, but with the caveat that they are both (especially Miller) heavy reading with an older style, more on the mentality/worldview and less on daily life.

Edit to add: I also enjoyed the Witch. I'm a scholar of early America (mainly the Revolutionary era, but I had to read substantively on the colonial period for my comprehensive exams), and I think they did a reasonably good job of recreating the era. They did not quite capture all the nuance of their religious views/stance on salvation, damnation, etc., but I think they certainly did well for the amount of time allowed and the amount of depth that you can feasibly have in a movie that's primary purpose is entertainment and that ultimately descends into supernatural/horror. I frequently recommend it.

beautiful and thorough responses! I greatly appreciate both of you