I can’t comment on all of the hymns you mentioned. However, I don’t think there’s a specific list of hymns which have been banned - but there are guidelines with regard to what is suitable and what is not. Ultimately, the purpose of a hymn is the glorification of God and then the sanctification of the people - and one example of what the purpose of a hymn is
not: the function of a hymn is not to make the people happy or feel good!
A good place to start is to look at the words of the hymn. Are they theologically sound? If not, then the hymn is not suitable - it is as simple as that. Some hymns appear on the surface to be suitable, though they may not be - especially some that appear to have a Eucharistic theme, but reading further into the verses you may find that the theology denies the Real Presence of Christ in the Eucharist. Such hymns are not suitable. So, it is very important to focus on the words - not all Protestant hymns are incompatible with Catholic theology, so don’t immediately dismiss them; hymns that are catechetical are good, as are those which lead the people spiritually deeper into the sacred mysteries being celebrated.
There is also the question of “horizontal” versus “vertical” music. Music with a horizontal focus tends not to be directed at God, but rather a conversation
about God with other members of the congregation: this may be the trouble with
Our God is an Awesome God. Who is one singing to when one sings this hymns? It seems to me that it’s the congregation singing to the congregation…not the purpose of a hymn. There is a good article
HERE regarding the “Ritus Narcissus” (i.e. singing to ourselves and celebrating ourselves).
If the hymn survives in terms of its theological suitability, being directed at God, etc. etc., then it is good to consider if it is suitable musically. There is a “sacred style” - and the most perfect is Gregorian Chant followed by sacred polyphony. Music which is too closely related to secular “pop” music should not be used in the Mass - many church choirs (including my own at the time I took over as director) are of the (misguided) opinion that church music today
has to be upbeat, or that church music need not necessarily be of a different style to secular music. But the point is that when sacred music is clouded by secular influences, the sacredness of it is eroded - how are peoples minds being lifted to God in the Mass when they are bombarded with exactly the same style of music that was playing in the car on the way to Mass, or which was on the radio at breakfast time? Sacred music necessarily has to be different - the function of sacred music demands this. Related to the actual style of the music is the instruments which are required to accompany the piece - not all instruments are suitable for use at Mass. The Church teaches that the most suitable instrument for accompanying the voice is the organ. Instruments which are immediately associated with secular music should not be used.
I suggest that you go to the
Adoremus website and browse some of their articles - there are many good articles on what constitutes “good” church music.