Thinkpads generally work out of the box without any tweaking. I'd suggest using a distro with a recent kernel and you shouldn't have any problems.
Ram-wise, 16Gi is plenty for me. The nvme ssd more than makes up for any issues. I regularly run multiple IntelliJ/Goland windows, docker containers, VMs, etc. without a problem. If I need more, I have a proper desktop. Laptops are meant to be portable.
The carbon is half a pound lighter than the comparable macbook pro, and better in all respects that matter to me - keyboard, weight, battery life, repairability, durability, linux compatibility.
A fairer comparison to the 15" machine would be either the T580 or P51 series which has a similar choice of up to 32GB RAM and up to even Xeon processors if that's your bag - perhaps not quite as sleek as the Dell, but then it is a Thinkpad.