At the time, had 50u/6d, and played for a bit over an hour on my PC which is hardwired (located in Northern California). I generally thought it was fine. I had previously played some PSNow stuff a few years prior (mainly just trying a few different games, but I completed Resistance 3 without issue), and it compared favorably. Launching it was fairly painless, and when not in motion it looked great. It got a bit worse looking when moving due to compression artifacts (sort of like a bit better-than-normal 1080p Youtube stream), but was not really an issue for the majority of my time playing. The input latency didn't seem to hinder me much (if at all), and felt similar to playing Odyssey on my PS4 Pro (although visually it was a large step down due to the resolution and artifacting). Having recently played Odyssey on console, the 30fps cap didn't bother me (although if they are now shooting for 60fps for the baseline, I'm assuming it'd feel even better?).
I did occasionally run into bouts where the resolution would drop considerably, I assume due to some kind of issue on my network (I've been having an issue with BFV where my ping will skyrocket to 300-500 for 10 seconds or so every couple hours; haven't noticed it in other games though so idk). It was pretty impressive how the latency didn't change much in those instances though, so although the game looked significantly worse, it was actually still playable. I don't think I'd give up a dedicated device like my consoles or PC, but for people that are OK with playing on a smaller screen like a phone/tablet (which I just can't get into), or possibly an older laptop on the couch or something, it'd be totally fine. No idea what it'd be like in multiplayer situations though. (as a note, I have since played the native PC version, running at 1440p and 60+fps. Obviously much nicer looking, and better playing, but I still don't think the streaming version was that bad).