Noindex if query parameters are present? [#3566185]

**For now this issue is for discussion first, to find good ways to solve that, as Metatag is very widely used**
(Remove this comment once we have a solid plan)

Problem/Motivation

I came across an issue in Google Search Console that lists lots of URLs from facets or search that use query parameters (see below).

The project uses facets and search heavily, which results in URLs like this after filtering:
https://www.example.com/de?search=lorem&tags%5B%5D=206
...

And because that page - without the query parameters - should be indexed (and it's the frontpage) has <meta name="robots" content="index, follow" /> from metatags.

Looking for similar reports and solutions I found this issue:
https://www.drupal.org/project/facets/issues/3095160#comment-16403323

Steps to reproduce

Use facets, views filters or other query parameter filtering solutions and see these pages indexed.

Also see https://www.peakhour.io/blog/how-to-exclude-query-string-parameters-from...

Proposed resolution

Add a setting to override the "index" robots meta tag (or remove it or even set noindex), if any (or certain) query parameters are present in the URL?