I have a 2020 MacBook Pro M1 8GB/256GB I used for work. multiple windows of outlook open, multiple larger pots (20mb+), word, excel, 5-10 tabs, multiple PDFS, mail, messages, WhatsApp, calendar, etc etc etc.
Handles just fine and not slow at all, and so did my 2014 MacBook Pro before I replaced it.
memory swap is high however, I just looked and swap used is 7.65GB.
The only app I notice is sow, even when it's the only one running, is Photos in terms of rendering the photo for Canon R6 photos. Usually I have to go into edit mode for the pic to fully render. Not sure if this is just the sh*tty Photos app or not.
I am in the market for a new MBP or MBA but more because of wanting to go to 2-4TB of storage. When I do, I will look to get 16b or 32GB of RAM, just because it makes me feel better!