Thanks to you both for the replies. Was all set to order the new M2 Air thinking it would be able to drive two external screens however was surprised to see this wasn’t the case.
The MacBook Pro would be overkill for my basic office application needs.
I thought about a Mac mini as a possibility but then wouldn’t have the portability to move between offices.
If I can get a used Intel 2020 MacBook Air for around $600-$700 would that be worth it? If not then back to the drawing board.
Performance, thermals and battery life are just so superior to the Intel model that dual monitor would have to be far more important than the other stuff. It is very easy to become spoiled by Apple Silicon that I think that the vast majority overlook the monitor support issue. You could also use a USB to HDMI/DisplayPort adapter to get a second monitor off of it.
I am running three monitors off my M1 Mac mini (2x4k + 1xQHD) using an open source project and it works quite well. I'm using an old 2010 iMac for the third display. I have tested 4k and plan to test 5k.