MikeAqua:
Thanks All. It sounds like I am on the right track. To answer many useful comments in one place.
Apple: I'm too cheap. Plus I don't have any other apple products
You can get a refurbished Macbook Air with an M2 chip for $1529 from the Apple website. Apple refurbished is really good in my experience and comes with a full 12 month warranty (and CGA). The base model only as 8GB of RAM but likely good enough for what you need. It is basically impossible to upgrade but tends to hold value fairly well, so sell it when you want to upgrade. I don't see the higher end macs as good value for money, but I think the base model air is actually pretty good bang for buck compared to what you are looking at getting.