Yes I realized that a number pad would be best.

Can I re-link all of the keys to do whatever I want with a usb number pad?

Will I have to download a certain script? How well will this run between the adobe suite and resolve? Maybe Avid too depending on my future projects.

Is a color coded keyboard really that useful? I honestly don't have difficulty memorizing shortcuts and i regularly change up shortcuts to suit my individual quirks as an editor. But maybe my inexperience is showing here.

I also have been seeing keyboards with dials for zooming/volume. That seems super useful actually. I really like the elegance and simplicity of this, and the fact that it's macbook/pc. Might end up buying it: https://www.amazon.com/dp/B07BS1YH4P?tag=georiot-us-default-20&th=1&psc=1&ascsubtag=dcw-us-1134189145535754400-20

Paired with a number pad I think I could get exactly what I want.