Hi thanks for opening this issue. Nothing stands out yet as an obvious culprit to me. Please provide the full traceback and full error message for the various exceptions you are experiencing. You can redact and sensitive info like host names or user names.
Please also provide the output of pip list so we can determine if you are using PyOpenSSL or not.
Can you also describe what server product (atlas dedicated, atlas free tier) and version (MongoDB 4.0, 5.0, etc) you are using?