Mystery could evoke either fear or awe. Something mysterious implies the unknown, for which no explanation is yet available.
When you don’t know what to expect, it could make you fearful of what lies hidden. On the other hand, mystery could get you excited at the prospect of a surprise lurking to be discovered.