Update cibuildwheel configs to implement meaningful tests

[absurdfarce]

We've had a couple cases now in which wheel builds succeeded but were missing a significant component, usually some part of the native code build for it's platform. We should be able to leverage cibuildwheels support for testing built wheels to detect these cases and (at minimum) alert us of the change or (ideally) fail the build.

Examples include:

• cassandra-driver for Python 3.12 Linux is compiled without libev support (PYTHON-1378)
• Windows build for Python 3.12 compiled without libev support (PYTHON-1386)
• No C extension .so files in published binary Python whl packages of 3.29.3 (PYTHON-1428)