It’s not likely the CPU will be your limiting factor. At least with Adobe, CPU requirements are very easy to meet. But it uses a lot of ram, 16gb or 32gb recommended, and the GPU might be another story. Depends on what you’re doing.
For rendering work, Nvidia cards are still reportedly getting it done faster in 2023. Pro Graphics cards from either brand (AMD Radeon Pro, Nvidia Quattro) are meant for this, getting it done faster still, and cost extra for the privilege.
Check the recommended specs for the app you intend to run. For example, Adobe Premiere Pro recommends a 4gb card (or a 6gb card for 4k) renders in 2023. Pro graphics cards get expensive fast as you climb the product stack, and you can hit a point of diminishing returns.
Adobe Premiere Pro recommended specs
The Framework 16 offers that RX7700s. If that complies with the software vendor’s recommended specs, fine, $600 solution. But if you need something bigger then you may have a use case for either external graphics (eGPU) or just a different computer.
As to external graphics, you could buy a Razer Core X… or follow the thread below, where some community members are engineering something faster. They have a basic design at time of writing, and are looking at potential improvements.