Yes SSD and RAM are simple to replace. There are two SSD NVME slots in fact, and only one is used by default so you can add another.

It seems like the libraries are server specific. So it’ll probably just be saved to whichever server owns the library you’re using.

Dell XPS 13 checks all your boxes except good speakers.

I have the XPS 15 9510 model. Intel 13th gen i7, backlit keyboard, great trackpad, sleek design. It came with 16GB ram but I replaced with 32.

I bought it “refurb” on eBay last May SPECIFICALLY because I wanted the most Mac-like PC. Running Arch Linux from day one and it’s been rock solid and super fast. The speakers aren’t great and the mic is pretty bad. But I usually use headphones or external speakers when docked.

I honestly am very happy with it and it was only like $550.

I spent a bunch of time before this comparing new computers; between Thinkbooks, Framework, Tuxedo, XPS. In the end I decided what I wanted didn’t require it to be new. I was only concerned about degraded battery but I can replace that myself when the time comes.

I don’t want to plug the seller but they’re constantly selling these on eBay so you’ll probably see them if you search.

Side note I disabled the NVIDIA GPU and only use the Intel iGPU which has saved a lot of battery.