I find them kinda relaxing, actually? Not on the first playthrough, of course -- they're always very tense on the first run -- but they quickly lose their edge once you know what's coming and from where. They become simple games of memorization then. Makes it easy to settle into their rhythms when I need to de-stress or generally distract myself.
I usually end up getting stressed more from online multiplayer games due to the constant pressure to perform well so as not to be a burden on the team. It's why I tend to avoid most multiplayer games like the plague.