Physical space is actually a huge issue
Ah then I’d recommend keep the existing machine as the server (it sounds like it’s serving you well hardware wise), and get a SFF machine for regular desktop use, be that a new build or a used office machine. The trick will be in migrating the server to Linux, and without endangering your data in the process.
Agree with others, Vaultwarden is probably your best bet. I’ve found the default app to be a little flaky, but ended up using Keyguard, which I’ve found really good.
I used to use Keypass+Syncthing, but found sync conflicts too often (due to Syncthing support for Android), hence the switch.