I always wanted to open an indie book store + coffee shop and had a similar analysis. I read recently they are having a come back.

Barnes and noble is opening in my city after a decade ago books a million closed and our local indie closed during Covid.