I’ll second @ogiewon 's recommendation for Hubitat. I and @stephack are also owners. However, you said you are investing in ST and exicted about it, so I think it is only fair to explore all the options.
You can find node.js for Windows here
In the original post, @njschwartz did say there was an issue with OpenSSL certs. I don’t know if a workaround was ever created. @BHO has continued to contribute a fair amount of the work with this project on ST and may be able to provide some insight. I have heard of running node.js in a Docker container on Windows, but don’t know the details of that setup.
Now, as a Hubitat user, I would strongly suggest you consider that as an option. It’s everything you want with this setup, without any dependency on cloud for this.