I've heard Mass celebrated in several languages, but there is a beauty and solemnity in the Latin Tridentine Mass that gives great glory to God-even in the way the congregation responds, with an extraordinary reverence.
I believe the Maronite Church (Catholic BTW) has some of their prayers in Aramaic. I’m not sure about the Melkite Catholic Church.