While I've no idea of your exact needs, I've been a happy Affinity customer for almost 3 years now (freelance web dev/designer).

It has everything I need (vector work, photo editing), and no subscription.

It seems our designer team doesn't really use Photoshop. They switched to Figma from XD and most of their workflows don't use Adobe software. They still use Illustrator occasionally, but they're looking at Inkscape atm. If you have Photoshop in your workflow, you're kinda fucked. https://www.photopea.com/ might be an option, but it's not a 1:1 replacement. If you need Lightroom, then Darktable is a good alternative. It's a bit janky here and there, but fully functional and stable. If you're using Premiere then for fox sake switch to DaVinci Resolve already, it's so much better than everything else and is free for many workflows and even for commercial use.