Turn on pyright `reportOptionalIterable`

[Avasam]

Mostly Adding generics and NoReturn so types can be properly restricted.

[Avasam]

CC @vernondcole since this requires adodbapi changes as well, but they're pretty inoffensive (only annotations or in examples)