The only limitation I notice is that I can only have a single external display.
For work I am developing a massive JVM monolith server application and even the M1 Pro 16" takes minutes for it just to start up. Compilation is also slow with millions of lines of code. I have SQL Server running on an x86 Linux VM with Rosetta in Docker. Need all the CPU I can get. The Macbook Air simply has less CPU performance and is thermally throttled. It would waste too much of my time.
For my personal hobby C++ coding, the Macbook Air 8GB would be enough.
But also, Airs used to be absolutely AWFUL devices in terms of performance when they were still intel. I think the stigma has stuck around.
Doesn't having to close background applications constantly absolutely maddening ?