For higher end stuff, you can play Alyx through Virtual Desktop on Quest. I haven't tried it myself yet, but I've watched the videos and apparently it is quite good assuming you get everything setup correctly.
The thing that most amazes me about how well this works is that I can actually get a great experience rendering remotely on a cloud pc (Shadow, 350 miles away) using VirtualDesktop or one of the other streaming solutions.
So there's a bit to be said for both approaches. But as far as the hardware goes, a decently powerful standalone device is still necessary for a lot of local operations such as view reprojection or frame interpolation that is necessary to make the remote experience usable.