Feature Request: Alternatives system à la Debian

It's been talked about many times in the past. We currently don't have a ticket to keep track of related issues/progress/comments, etc. The closest I can find is:

https://wiki.archlinux.org/title/User:Allan/Alternatives

The latest "drama" that would be solved by an alternatives system relates to faulty debug packages (cc @anthraxx). Please refer to the following tickets for example: