Sync read_csv's usecols types with pandas (or the reverse?)

[twoertwein]

          thanks @twoertwein .  There are still slight differences between `pandas-stubs` and `pandas` here.  Do you want to create an issue or PR for the stubs to align things?

Originally posted by @Dr-Irv in pandas-dev/pandas#55330 (review)