Since your post has been merged into this topic, I hope you’ll consider voting for this Wishlist by clicking or tapping the button above the initial post.
As an Android user, you also have the option of using a third-party notification interceptor app (e.g., BuzzKill, MacroDroid, Tasker) to achieve the goal you’re seeking. I’ve used MacroDroid to set custom notification sounds from specific cameras, @carverofchoice recently posted some details about how he uses BuzzKill to intercept and handle notifications (I imagine modifying those steps to have a selected sound play is probably fairly straightforward, though I haven’t done this), and @julian.benz recently posted a write-up about doing the same thing in Tasker.
I agree that this is something Wyze should build into the app, though, so that iOS users have the same customization options, and it’s why I’ve also voted for a related Wishlist topic: