Why are Scorpios known for their loyalty yet described as dangerous enemies when crossed?

How does a Scorpio's love for mystery and the unknown influence their decision-making and lifestyle choices?
How do you handle a conflict with a Scorpio, considering their tendency for silent resentment and strategic detachment?
Why do some people feel stressed about not giving a gift at a wedding, and how can hosts alleviate this pressure for their guests?