STYLE pre-commit autoupdate, and other cleanups
Summary of changes (separated out into separate commits for ease of review):

- run `pre-commit autoupdate`, bumping a few versions
- It's mostly using double-quotes in Cython files (cc @jbrockmendel 's suggestion in https://github.com/pandas-dev/pandas/pull/49866#discussion_r1030853463)
- remove some unused variables / imports from `pandas/_libs/parsers.pyx`
- rename variables named `l`, as that's a new flake8 check that disallows that, in:
  - `pandas/tests/frame/indexing/test_getitem.py`
  - `pandas/tests/io/pytables/test_round_trip.py`
  - `pandas/tests/io/pytables/test_round_trip.py`
- move `black` to local hooks, because like this it runs twice (!) as fast, [as they now compile with mypyc ](https://ichard26.github.io/blog/2022/05/compiling-black-with-mypyc-part-1/)
- add `--verbose` argument to CI job, so we can see how long each hook takes in CI
- move `yesqa` to the manual stage (so it only runs in CI), as it's kind of slow and unnecessary most of the time (I don't think I've ever had a local commit fail because of it)

---

If reviewing, I'd suggest looked at each commit separately as they're each self-contained
IMO would be better if each commit is a pull request as it would be easier to revert a specific change if for some reason there was an issue with one particular change here that's a fair point - I'll split it up then, thanks!