I have a feeling that RAM in an Intel Mac is somewhat different to RAM in a silicon Mac. I am not sure, and as you are an IT guy, hope you can explain. I am using a 15" Intel 2018 (made in April 2019), and it is still doing well after 5+ years. Sure, it has 16GB Ram, but with an older 8th gen i7. I'm doing more than what the OP has mentioned he'd do, and that MBP is running about 15 hours a day. The memory pressure never been to yellow. The MBP gets heated up, only when an OS update is going on, and after that it cools down, sometimes the palm rests are too cold. At that time, this MBP was manufactured, there were no silicon Macs. Of course, it was supposed to be quite high-end then.
Anyway, one day, I'd have to buy a silicon Mac. Not because this Intel MBP would die, but because of curiosity, just to try one out. Let's say, if I buy one in 2025, I'd be still doing the same work, and leisure use of that machine. I find the 16GB RAM Intel MBP is still too much for what I do with it. Because it has 16GB RAM, sometimes macOS would use ~12GB of that. If I do the same work on a Windows 11 laptop with 8GB RAM, that Windows laptop won't use even 6GB of it. I have 2 of them, a Lenovo and a Dell, which has 10gen and 11gen intel processors. When I use Linux on those laptops, they work even better.
I don't do any video editing ever. Some image editing, either with Preview or GIMP. I use Excel, Word and Skype, which maybe the biggest memory hoggers, not being native macOS. So, would 15" MBA with the M2/M3 chip 8GB RAM would be enough? Would the RAM on a silicon chip works differently than RAM with an Intel chip?