(DLL hell stopped being a problem a lot sooner than you probably think, too...)
Does not match my experience at work unfortunately.
Sometimes the issue is that people have tended to conflate "dll hell" and "dependency hell." That's an old pet peeve of mine and I realize it doesn't matter...
Abort, Retry, Fail?
FFFFFFFUUUUUUUUCCCCCCKKKKK!!!!!!
Also, to keep the size at least somewhat in check, unused parts of the base library are not included in the single-file mode.
You of course have to choose your target platform for this as it makes .exes for Windows, ELFs for Linux, etc.
If you want you can still choose to distribute IL DLLs and users then use their already installed dotnet on their machine to run them.
https://github.com/jart/cosmopolitan
(but, yeah, you probably want one version per target, even if hacks are cool)