I've been using a 14-inch M1 Max 64GB RAM MBP as a desktop-laptop for about a year. It's great.
I had an identically equipped Mac Studio, but the whine was a deal breaker, and I didn't want to bother with attempting repairs right at launch. So, I returned that for the MBP, got to work, and have really enjoyed using it. Having the fans stopped most of the time is nice (coming from a history of iMacs with audible fans at idle), though it spins up to be plainly audible (but not unpleasant) if you really load the GPU for an extended time.
I also have another 14-inch MBP M1 Pro base model that's my laptop-laptop, and it's really nice as a laptop, too. The screen in particular is great and would likely keep me from moving to a MBA as a laptop-laptop.
If I had that decision to make with current products, I'd consider the 16-inch (and try to figure out what the fan sound difference is between it and the 14 under load) and the Mac mini M2 Pro. But, the 14-inch MBP has been great, so that would be in the conversation again.