I think with the Adobe products, you're going to be stuck between a rock and a hard place.
I don't know if the main applications for CS4 are 64-bit, but I think that even CS6 has 32-bit installer and activation components that won't run under Catalina or Big Sur. Adobe no longer supports CS6, so I'm sure that goes for CS4.
If you go to subscribe to one of the Adobe Photography Plans, you'll probably find that the system requirements call for you to have one of the most three recent versions of macOS. The release of Sonoma caused Big Sur to drop off that list. If Adobe hasn't already stopped supporting Big Sur, they soon will. That might mean that you must "jump through hoops" to get unsupported versions of the Adobe applications that will run on Big Sur (but that will get no further features or bug fixes). It might mean that you can't get the Adobe applications at all. You need to ask them.