CLN: clean more uses of python2-style super()
- [x] xref #25725 & #26177

Simplifies the uses of ``super`` by converting to use python3 idioms. This is a followup to #26177, focusing on uses of ``super`` in class methods.

Also adds a check for python2-style uses of ``super`` in code_checks.sh.