I would suggest an older ThinkPad instead of a brand new one. Almost every operating system I know of targets them as a platform, you won’t run into issues with Wi-Fi cards and suspend/resume, and they are quite upgradable.

Some have hot-swappable batteries (no need to shut down just to switch to a fresh battery), they all have great keyboards, even ancient machines feel fast with a new SSD, and the cooling is miles better than an “ultrabook” design.

Whatever you do, I would caution against buying a machine for the specs. You’ll probably get something heavy, with poor battery life, and if you need more power, you should be doing those tasks on a remote system or a beefy “cloud” VPS instance anyway.