it depends with your workflow, I was also on this decision side of which to get, and I had the m2 air previously with 16gb ram and wasn't enough for my workflow. it would stutter and swap was being used enormously. if you are doing something like video editing and etc, it uses a lot of gpu power and for sure you would be benefitting from the max chipset either its m2 max or m3 max, if you are only doing casual workflow then m2 pro and m3 pro would be a choice to be made. for ram alone, it usually depends on how long also do you want to keep your device, rule of thumb these days is 16gb ram, but future proofing for 32gb would't hurt. in m3 respective this would be 18gb ram and 36 gb ram. u can also get away with m2 pro/max refurbished model
TLDR see how your workflows goes, and determine which u need. 32 gb ram / 36gb ram would be future proofing, and if you decide to take m2 models, watch out for the smaller ssd memory as it has lower memory speed. for m3 models the base is also fine speed wise l.