At their core, the majority of video games are power fantasies. They’re designed to make you feel superior to everything else around you, and even the most challenging experiences are ultimately supposed to be about overcoming adversity. In order to help you cope with rising difficulty curves, games usually throw you a lifeline or two in the form of a powerful weapon or item that’ll make you significantly harder to kill.
But sometimes, that very lifeline is enough to completely break your immersion in or enjoyment of a game. It might make things too easy for you, too hard for other players, or just render an otherwise lengthy and worthwhile game disposable.
The time spent retrieving these items is usually a lot more fun than actually wielding them. After all, as much effort as it might have been for King Arthur to pull Excalibur from the stone, it probably made chopping up bad guys far less satisfying.