I've got a 7800XT now and I moved from a 1070 and I've been happy with it overall. I'm on Fedora and I bought the 7800 kinda close to launch, so I went through some issues that seem to have been solved by now. Nothing that really made me go "gee I wish I hadn't switched".
I don't do anything related to streaming, or machine learning, so I can't really speak to it's ability with those, but gaming has been stable, and, aside from a now solved problem with rocm, it works fine with Blender cycles (at least on Fedora 40). Davinci Resolve has worked fine too. On launch, there wasn't VAAPI support for AV1, but that works just fine for me now. (VAAPI is the open source interface for GPU video acceleration).
Currently, I'd say the experience is perfectly fine.