A lot depends on the Pastor and the Director of Music. The ones we have now are really supportive of folks singing from the pews. If people tell me, "I don't sing well", I just tell them, "God gave you your voice, give it back to Him!"
LOL Ain't it the truth. My daughter and I used to go to the 7:30 Mass for a while. We called it "the Mass where people resolutely refuse to sing" I liked it fine, it was very quiet and reverent, but the guy with the organ in the balcony seemed a little frustrated.
Agreed on the singing.
God doesn't care how crappy we are....:)