Computer ratings are kind of random because there's no meaningful sample of them playing top players. They're obviously much stronger, but specific numbers are kind of meaningless beyond comparing them to other software which they have competed against.
But Stockfish is not going to beat Magnus with queen odds. Nakamura has beaten Lc0 with knight odds in blitz (though he got crushed overall), and queen odds in bullet, all while chatting on stream. And fast time controls favor computers simply because they're practically impossible to flag and will almost never miss a tactical idea.
So you would enjoy playing Magnus more than playing Stockfish. Because it would actually give you a chance. And that's the whole point of playing games: to enjoy them, and to both have a chance at winning, even if that chances is remote. Stockfish takes that joy away. For me, that makes Magnus far superior to Stockfish. If I want to lose a game playing with myself I'll play solitaire. Or better yet, I'll go read a book. But the chance to interact with a human at the peak of their skill would be unbeatable for me in terms of enjoyment, far to be preferred over playing a game with a computer program. Though I can see the satisfaction in programming a computer to be that good, I would not enjoy the game because the other side would not enjoy it either.
>So you would enjoy playing Magnus more than playing Stockfish.
Oh, no, I wouldn't enjoy playing him more. I'd enjoy playing Stockfish infinitely more because I could learn new strategies from it. Knowing you're going to lose allows you to learn from all moves and all mistakes.
Against Magnus, I'd have no chance. I'm barely over a 2000 rating. Magnus could play with queen odds and drunk off his ass while blindfolded and would wipe the floor with me.
Stockfish is currently rated 3644.
Lc0/AlphaZero was estimated to be rated 3800.
Stockfish would destroy Magnus even with queen odds.