I think that's a bit misinformed. Churchgoers get connection to community and most active churchgoers have positive emotional connections to times associated with church.
Now, those who go out of obligation and have negative experiences may agree with you, but church services are some of what I miss most from leaving the religion.
As someone who used to be in the latter group, I wouldn't call it motivation. More like habitual compliance.
I have many complaints specific to my experience of dragging myself to church, but the experience itself was incredibly neutral.