I am very concerned that you are attempting to extract pairwise comparisons from an interaction formula like 0 + Group*Sex + Age, because doing so is not statistically meaningfull. It is not a statistically correct analysis. You cannot analyse "main effects" in an interaction model without resolving the interactions first.
I have explained before on this forum that factorial interaction models are not usually helpful in genomic analyses. In your example, a much more biologically meaningful approach is usually to convert Group and Sex into a factor with 6 levels and to extract Sex-specific group comparisons. The limma makeContrasts() function makes this sort of analysis explicit and straightforward. By contrast, the statistical concepts of "main effects" do not correspond to anything that could be published in a good medical journal.
makeContrasts()` requires explicit contrasts because I think it is helpful for users to understand the comparisons they are making rather than extracting comparisons they might not understand from a complex model.
limma allows users to fit completely general linear models, more general than can be generated using R's model formulas. In general, it is not possible to predict what contrasts will be meaningful for the user, so the idea of automatically generating contrasts is simply not possible. Analyses need to be designed with the scientific hypotheses in mind. It is not the case that there is a standard universal analysis for each model formula.
In the simple case of an additive Group variable, it would be possible to automatically generate pairwise comparisons but I have been reluctant to do so. In the three group comparison you mention at the start of your question, it is the quite easy to specify the contrasts using makeContrasts() and the resulting code would be shorter and easier to understand than the emmeans code that you show. If the Group has a substantial number of levels, then I don't really want to encourage pairwise comparisons because I think that will generate a confusing analysis that is hard to interpret. I'd rather force users to think about what comparisons are most important, or perhaps do an F-test.