How can I force HomeKit to send me a SMS/Notification alert (or email) if the basement floods?
It depends on the manufacturer of the sensor you're using. If it supports HomeKit notifications, you can set them by pressing on the device's icon in the Home app.