I actually don't mind the horror stories. I don't like that people sometimes hide the less pleasant parts of life. Knowing what can happen and how things can go wrong rather than giving me anxiety makes me feel better prepared.
I know people who were 100% convinced they'd have dream births in a pool who had to have emergency c-sections and they seemed extra traumatized because they felt like failures as their dream birth plan wasn't possible.
For me, its just healthy baby and healthy mom. I couldn't care less how the baby is born and I hope I'm mentally prepared for what can happen. Also, hearing the consequences of certain choices etc makes me feel like I can potentially advocate for myself better.
I'm just that kind of person though and I imagine that people who share horror stories do so because they wish someone had prepared them for what might happen better.
With that said, the majority of people I know with kids had very straight forward births, including at home and many with no drugs. Its entirely probable :)