I ditched Intel last year and haven't looked back. For Excel sheets, Chrome tabs, and Zoom calls, Snapdragon X handles everything without breaking a sweat - and yeah, the battery actually does run two to three times longer than what I got out of older Intel machines. You're not looking at edge cases here; this is the mainstream experience now.
The software compatibility concern is way overblown at this point. Windows on ARM has matured enough that your everyday apps either run natively or through emulation without you noticing the difference. The only real gotcha is if you're dealing with some niche enterprise software or older hardware drivers, but for someone replacing a five-year-old Dell to do standard office work, you won't hit problems.
Here's what nobody mentions: buy from somewhere with a solid return window and actually test one for a week if you can. Battery numbers in ads mean nothing until you see your own usage patterns. If you're someone who keeps a laptop plugged in most of the time anyway, the battery advantage disappears and you might as well save money on an Intel model. But if you're the type who works from different rooms, cafes, or travels - Snapdragon X will genuinely outlast an older Intel chip by a full workday on a single charge. That's the real deciding factor, not the specs sheets.