I have all of the CPU main models except the latest AMD. So latest Intel, Snapdragon X Plus, even the former Snapdragon based machines (Lenovo X13s).
I have Dell Inspiron 14 Plus - Snapdragon. Basically if you use standard software it works like a dream, has incredible battery life and works very quietly. Not had any major issues with it, just does what it should and is very fast. Will not run all the software I normally use (VPNs are really bad) but there are solutions to everything.
I have a Lenovo Yoga Slim 7 (latest Intel chips) - it has been painful. Bad drivers, won't run Linux (a BIOS issue it seems) and lots of issues with Windows updates, GPU drivers (had to abandon Lenovo drivers and use Intel ones, but Windows keeps trying to overwrite those). It is a quiet machine, battery life for an Intel is very good, but honestly - I'm not thrilled with it.
I also have a ThinkPad X13 Gen 4 (so 13th Gen Intel). Everything runs on this, but it blows a bit loud under Windows but is utterly silent under Linux. Basically this is my 'go to machine' under linux (Fedora) and is nice and light with good build quality. It also was the cheapest machine to buy (stock clearance deal was a steal).
Conclusions - any new processor has compatibility issues it would seem. The speed of driver release is the critical factor. After 3 months my Lenovo Slim 7 still cannot run Linux, and still has weird driver glitches. Otherwise it is a nice machine. Qualcomm are actually releasing driver updates faster, and my 'cutting edge' Dell quickly became very easy to use. If you want 100% peace of mind - buy an older gen Intel or AMD...