> - I would love if VSCode could detect the technologies my project uses and just install/use the proper plugins for me

VSCode does this already, if it detects a new language it suggests installing a new plugin. I don't know the criteria it follows to recommend a plugin, perhaps it only does it with some official plugins, but it has showed me this a few times.