I can answer this. I have a very similar workload to OP. I've found myself with resolve, affinity photo, chrome, vscode, spotify, ect open simultaneously, and have had absolutely zero struggle on my 8gb air.

If you become "enlightened" you can notice that sometimes when you, say, open your spotify window after a long time elsewhere, the spotify is briefly unresponsive. Not in a way you notice, more in the sense that if you are looking for it, you can see hints it is swapping.

The only time I wish I had more is when I got into iOS development and began running VMs on my mac.