I think package managers just need to get smarter. The DE should provide some default use cases, but once you encounter a file you cannot open the OS should just install the appropriate app.
And the DE should offer a few more activities that once selected install the additionally needed software.