Wittgenstein went through his own time of crisis. Contemplating suicide, he stumbled upon a bookstore which had only one book for sale: Tolstoy's Gospel in Brief. The book rescued him from depression and he was soon recommending it to anyone having problems. There are echos of the book's influence, and his respect for religious faith, throughout his life.
Although not the main focus of his work, Wittgenstein's beliefs are intriguing given his enormous influence on modern philosophy. Academic philosophers, many of whom hold Wittgenstein in high esteem, aren't often characterized as particularly religious. But maybe there is something that makes sense here. Somewhat similar to Tolstoy, Wittgenstein did not believe that we could really talk sensibly about the mystical side of religion. For him it seems that religion provides a way of thinking about how we should live, rules that just make sense. That's about as far as we humans can go.
Perhaps Tolstoy and Wittgenstein may be seen as prophets of sort, that is, as people who take religion and life so seriously that, while remaining outside of conventional beliefs, illuminate key aspects of that belief. Tolstoy wanted us to be happier people who loved one another. Wittgenstein wanted to lead a disciplined, ethical life. Still, a life of faith void of the mystical isn't for everyone. Perhaps Wittgenstein himself captured this well in saying, "Don't for heaven's sake, be afraid to talk nonsense! But you must pay attention to your nonsense." That may be the best we can do as far as reason and religion are concerned.