I am also a non-believer, but I think there is room for religion even for those who have a difficult time with the "fairy tale" aspect of it. Personally, I do not, but I'm thinking about giving it a shot.
The thing is that the stories in religious books help paint a picture of life and offer anecdotes on how one can navigate it. There is no need to look for enlightenment, just practical advice on how to deal with tough life situations and help you find motivation and strength to power through. Thousands of years of observing and documenting people's lives through stories and metaphors has value, even for us non-believers.
I think you'd even be surprised how many people who regularly attend church services don't actually believe in the mystic aspect of it all; it's the community and guidance that have the most value to them.
You can pick and choose philosophy and morals from a religion (or multiple religions) without buying the whole farm. To me, this seems like the right way to go. Cherry pick the good stuff and ignore the cruel parts and weird, supernatural stuff.
Church selection seems to play a big role. I don't know too much about it but from other commenters, there are apparently churches that emphasize the mysticism and paranormal side of Christianity, some that focus on the texts, some that mostly deal with hero-worship and the hero's origin story, some that are basically political Trump rallies, and some more laid back ones that are basically social/music clubs.
The thing is that the stories in religious books help paint a picture of life and offer anecdotes on how one can navigate it. There is no need to look for enlightenment, just practical advice on how to deal with tough life situations and help you find motivation and strength to power through. Thousands of years of observing and documenting people's lives through stories and metaphors has value, even for us non-believers.
I think you'd even be surprised how many people who regularly attend church services don't actually believe in the mystic aspect of it all; it's the community and guidance that have the most value to them.