Most of the strong hymns sung in Catholic parishes are Protestant in origin.  If you want good congregational singing attend a parish that is predominately African-America or Hispanic.  White bread parishes tend to be terminally borrrrrrrrrrrrring in their approach to making a joyful noise unto the Lord.