I think you're right, and that for most people (but not me), science and rationality doesn't offer this.
The important question is, why do people need this? Fear of death? Need to belong to a tribe? Whats important: "social" or "spiritual"?
Until we we know this there won't be successful "science based philosophy" (as nnq termed it) that avoids the pathological aspects of religion.
I'm not religious and don't spend much time pondering science, though I do at least try to stretch myself mentally in various ways but solving a puzzle of some kind seems like a far cry from religion.
I consider a tough scientific or technical or technical problem enlightening because it shows you the limits of your mind and how much you don't know or don't understand - this makes you more humble and teaches you to accept that you will always be surrounded by deep "mysteries" that you will never have the resources to comprehend. And otoh, when you finally solve a hard and deep problem that brought you to the limits of your mind, you realized that even the limits were an illusion and that your mind could maybe even comprehend the entire universe. For me it's easy and natural to find spirituality in science and technology, but I understand that people like me are basically "anomalies" and I understand other people's need for the more "magical" type of spirituality and for having it as a social thing (and I know there are other types of "anomalies" as well, not in bad sense - the one who can just take science and understanding "as is" with no need for spirituality). This is why I think there is huge unsatisfied market for all sorts of very different "spiritual products"!