I haven't got a church in the game (but would totally buy an Old Time Religion Stuff Pack that had callbacks to Sims Medieval), but I've put a fair bit of effort into my Honored Dead cemetery in Willow Creek, which has a lovely contemplative motif around the gravestones of sims who made memorable contributions to the world they lived in when they were alive.
I have another graveyard that's more like a landfill, which is far less thought out aesthetically speaking. It's just a place to dump bodies. But the Honored Dead fits into the religious leitmotif of my world.