Consolidate the "Project Summaries" by removing items and grouping the remaining ones

Should we consolidate the list "Project Summaries" a bit? Currently it is very long, and the order is quite random. I'd propose two changes to mitigate that:

1. remove things that are not really relevant
2. structure the items by use case

Below there's a list of all projects currently listed, with a remark about last update and "github popularity". In my opinion we could remove half of the projects here and group the remaining ones by use case.

For the non-pypa projects I suggest to remove the ones that are clearly unmaintained and (rather aggressively) the ones with a very low "github popularity". For the pypa projects, we could remove the more "fringe" cases projects, but we may not have to. Again, the goal being to have a useful overview for the users about the tools of the trade instead of a random selection of things with little relation to each other.

The grouping by use case is a bit more difficult as we'd need to settle for a set of tags or so first before we can start grouping the items accordingly.

Start by reviewing the current “Project Summaries” page and the complete project inventory in this issue. Identify which projects remain and establish use-case groupings or tags before editing. Done means the overview is shorter, organized by agreed use cases, and excludes projects judged irrelevant or unmaintained.