This is a weird one but the King's Fall raid in Destiny is a work of art. When it first dropped it was the most perfect mix of fun and frustration. It required FPS skill, really solid communication, puzzle solving, composure, and platforming.