CS2 being ranked higher than Siege and Fortnite is really misguided. It’s been almost the same game since before the internet. Siege was a welcome improvement on the same formula. Fortnite continues to innovate with new games and new modes, all appealing to a wide range of people and skill groups. Even its main mode sees drastic changes with each season. It keeps things fresh, which is vital for a live service game like those three.
It’s a great game but I wouldn’t call it uplifting at all. Some of the why is already in your comment. Some people may also get frustrated by being in a loop and having to start over time after time. Some of the puzzles aren’t easy, which again may add to the frustration.