Jeff,
We use Mogen David's Concord Grape. It's sweeter than most wines but seems to be accepted by everybody in our church. We tried a Merlot once and got a number of complaints that it was too strong, so we went back to the Concord grape. It's relatively cheap too!
Jim