I went from a 14" MacBook Pro to an M1 MacBook Air. I am a professional UX Designer who has pretty intense workloads. Nothing crazy, but more than the average person and I was worried that the Air would have issues. I purchased the base model with 16 GBs of RAM.
No performance issues whatsoever. What I did notice were the intangibles the Air line gives that can't be described on a tech spec sheet... fanless engineering is way underrated. Battery Life improvements. Ultraportability allowing me to work remotely out of the home easier (I didnt think a .7 pound and a little bit thinner chassis would be all that noticeable, but I can't go back ever again). The ONLY thing I miss at times with the Pro is that gorgeous screen.
My wife is now going to school and took my M1 Air, and I just purchased an M2 Air with 16 GBs of RAM and a 512GB SSD. I could have gotten the 14" Pro for $1599, about $100 less, but the better battery life, thinness, and fanless experience are well worth the slight cost in performance, worse screen, and lack of ports.