As a compromise between Catholic and Presbyterian, I've raised the children in a liberal Episcopalian church. It was a big change from what I was used to but it has been a wonderful education for the children. The emphasis on outreach and mission trips has been a big influence on the kids as they grew older. I've been very impressed with the church school and the music program. Episcopalian churches vary at this time in their approach to social issues but if you find one that says it is welcoming and diverse, it should be just that.
My husband's family never embraced this decision fully although they attended holiday events. My husband never felt he could take communion although our church is very open to everyone taking communion who is "reverent."
My background sounds similar to yours, even a minister grandparent, and I'd been baptized Congregational, raised in a Presbyterian church, and then my parents switched to a Methodist church after I left. I was married in a Catholic church but it didn't feel right. It seemed like every sermon was about women cooking and cleaning - I was probably extra sensitive and ironically I've spent a huge chunk of time as a stay at home mom. I was kind of agnostic in my twenties. I'd been in relationships that ended because of diverse religions. I've been really surprised how my faith has grown and how much a part of my kids lives our church has been. I didn't expect that but it just slowly happened and I am really grateful. I've felt such peace even during tough times and I can't explain that except for faith.