The word means beautiful, gorgeous, exquisite, but it sounds so boring and plain, most people think it's like a sub way or something because of the prefix.

Because it means the end of something and most things you don't want to end.