I really like my Wyze cameras, especially their night sensors and SD card support. They are cheap, the optional cloud sub is cheap, their nighttime/low-light imagery is really good (both in color, with their special sensor, and in black/white with built-in infrared lighting).

Each camera is only $26 and works great. In fact I prefer their ecosystem to the super-bloated Ring and Nest ones that I used to have.

They have sound-activated recording and some basic AI features (package dropped off, I see a pet, your wife is home, etc.) but not specific sound detection.