As someone whose childhood included attendance to various churches, this mostly reflects my experience. That's not to say that it can't or won't produce deep connections, but it is in my estimation more unlikely than not, particularly if there's anything about oneself that the church doesn't agree with or if commitment to that particular denomination hasn't been established.
Personally speaking I find the need to conform to the church's norms/expectations to not be ostracized at minimum chafing and in the worst case stifling. The third place and social aspects can be nice but being told how to live and exist isn't.