I love this discussion because I have such a similar situation! My DH and I were both raised Catholic and are "half" practicing Catholics. We go to church in waves, sometimes consistent, then a few weeks off, etc. Also have a 2 & 4 year old so makes the Catholic Mass experience difficult. Anyway, we too like the tradition and community of the church, more so than the doctrine, etc. I can relate to 2giftgirls story about Butter, as my DS9 has read all the Percy Jackson/Rick Riordan series (some books twice and three times!). In the beginning, when I saw him getting caught up in the fantasy aspect of it, I had to explain that it was fiction and explained what mythology was, this helped. However, I did not use any comparison to our "God", as I knew that would provoke questions.
Funny story though, my DS9 had to do a power point presentation at school, and the parents were invited-I didn't know his topic beforehand but he was really excited about it. You can imagine how squeamish I was when he got up for his presentation and it was on Hades, the god of the underworld! That was one of those awkward moments as a parent-but I have to laugh about it now, simply because we live in a very "bible belt" part of the country. I just try to keep the faith light, not to heavy, and if the questions arise, then handle them as they come. Luckily he goes to a school with many different religions, which I, being raised a Catholic school student all my life, was never exposed to. I like the fact that he knows other religions and sees and somewhat understands their traditions as well. Good luck!