You know, I still don't see why they did all that with Sisko's mother. I don't even want to call her Sarah Sisko because like, did she even want to get married? Have a kid? "Possessed by a Prophet" doesn't seem to leave a lot of room for free will; it definitely doesn't exactly look good for the Prophets and brings up a lot of questions about bodily autonomy that the show just completely fails to engage with.
And it doesn't even make that much sense for the Prophets - they're all about non-linear time and being kind of weird and non-corporeal, conceiving a child just feels so... earthly.
If they felt the need to arrange things, it should have been weirder. More... intangible. Sarah finds the necklace at a street market or something, the seller has no idea where it came from, but picking it up leads her to run into Joseph, who asks her out, and eventually they get married and have a kid, Ben. They can even keep her disappearance - either she dies, traumatically enough Joseph never speaks of her, or she leaves of her own accord, the showrunners either pulling the post-partum depression card or just making her a deadbeat mom (enough with deadbeat dads! let's get some deadbeat moms!).
Leave it questionable. Leave it mysterious! Did the Prophets place the necklace in her path? How and why? What exactly did it do? Who cares! It made Ben possible, through the will of the Prophets. Is that... how they reproduce? Through random acts of kismet? Sure! We love a weird noncorporeal species. They do everything else through acts of fate, why not reproduce that way too?
And leave poor Sarah alone - let her have as much choice in life as anyone does, with people like the Prophets hanging around XD Who needs to go around possessing people when the power of fate is in your hands?








