when I searched best laptop for finance (my profession) to be used as a docking station... the 14 inch MacBook Pro rated number 1 on nearly every list....MBA sounds like a better option for you given you value portability. Besides when you're at home you can always use a docking station for more USB ports, bigger monitor, external keyboard/mouse, etc.
For me, I have the 14" M1 Pro and am very happy with it but I acknowledge it's not *as* portable as one of the smaller Macbooks due to the weight/size. I don't carry it everyday so not an issue for me. That being said, in hindsight, given I mostly use it docked at home, the M2 Macbook Air probably would've served me equally well.
even opening a dozen excel files that have extensive amounts of macros/pivot tables....the machine flies...just takes a bit to get used to the fact I can't just snap 2 excel files side by side... I have to hover over the green button...but all my formulas work when building complex models...and I can easily dock it to two monitors while using the laptop screen as an email display...
the 14inch MacBook Pro is the best business laptop on the market....and perfect to use as a docked workstation with lots of periphersls