My favorite hymns have Hebrew names, since they're from Jewish services. The hymns I listed here are meant to be sung by everybody in the synagogue; they have powerful, yet easy-to-follow melodies, designed to draw in the congregation. (There are more hymns that just these three.) Interestingly, some modern Israeli artists actually use melodies derived from hymns to write trance/techno songs. From what I've listened to, the end result is incredible.
-> Shalom Aleichem (a song for welcoming Shabbat)
-> Adon Olam (a song depicting the glory of God)
-> Yigdal (a poetic song describing the 13 principles of Jewish faith)