This has been interesting to read. I didn't post when I first read the OP because I wanted to see what others said first! (chicken! )
I had a similar dilemma a couple of years back, and really wondered if we'd made the right choice of church when we first moved to the area. I felt very drawn to the local non-denominational community church, which has a very young and lively congregation, lots of young families, soft-rock-God-songs (which I actually quite enjoyed at the one service I attended, but OMG it was loud ). Instead, though, we ended up with the very staid and sensible local CofE church, for lots of sensible reasons, like the link to Beavers, the mulit-generational congregation (we have no family nearby), the toddler group, etc etc.
I've had my ups and downs with the church and have spent several services trying not to bang my head against the back of the pew in front through boredom and fristration at the turgid, tuneless hymns (could they not at least play them a bit quicker? I mean - we're meant to be happy, right?), irritation at the feeling of exclusion because the eucharist is sung and they seem to change the blooming tune every week so I can't join in with the responses, and so on.
But, having decided to stick with it I did very much as a PP said and got stuck in, volunteering to lead the toddler services, go on the sunday school rota, help set up a house group for young mums etc, and now feel very much a part of the community and, in showing willing, also realised that our vicar was actually desperate for younger people to get more involved and inject some life into the community.
There are still many things that frustrate me, but the friends I have made there are wonderful (from the grandmotherly ladies that help out on the creche rota at the house group, right down to the babies) and the pros now far outweigh the cons. Also, our preaching team is as intellectually robust as you could hope to find anywhere, which for me is really important.
But, yes, going back to your OP and what a couple of others have said; ask not what your church can do for you, but what you can do for your church!
HTH and good luck. Let us know?