It would be nice to get more documentation / explanations about when they should be used / in what way they differ / intention of the ._pth isolation mode / why some things are missing from them etc.
Maybe it already exists? 4. Using Python on Windows — Python 3.12.1 documentation says the nuget package is for CI only, while the embeddable package is for distribution with applications written in Python (4.4.1) or applications written in native code (4.4.2). I just noticed further down (4.9) contains some more information, although still a bit sparse.