CI/TYP: enable reportGeneralTypeIssues for subset of files
Second attempt at enabling pyright's most important type checking rule (reportGeneralTypeIssues). Instead of having many file-based ignores as in  #44855, this PR adds a second pyright configuration file just for reportGeneralTypeIssues and lists all excluded file in this one config file.
If we encounter pyright errors in the future that are difficult to fix but not reported by mypy, we have a few options:

1. add the entire file to the exclude list
2. add a file-based comments `# pyright: reportGeneralTypeIssues = false`
3. add a comment at the offending line `# pyright: ignore` or `# pyright: ignore [reportGeneralTypeIssues]`
4. if it is a mistake in pyright: report it and there is probably a release within less than a week with the fix (the release cycle of pyright is amazingly fast)

As long as the exclude list is long, I would simply add the entire file to the exclude list. Once the exclude list becomes reasonably small, we could transition to using line-based comments (currently we would need to add ~650 line-based comments) and merge the two pyright configurations (pyproject.toml and pyright_reportGeneralTypeIssues.json). Thanks @twoertwein. Would be great to create an issue to tackle the typing issues in the config file  