I really feared sleep. But in our case after the first 4 or 5 months with both DCs it has been great, easy even.
Number 2 is 13 months and sleeps from 6.30am until when we go into his room to get him around 8.30am. He sings until we go in to scoop him out of his cot.
Number 1 is 4 and sleeps from 7pm until when we go into room to get her, usually around 8am or later in the holidays. She amuses herself until one of us goes in to get her.
I actively chose to bottle feed so my partner could do nights for the first 2 weeks to allow me to recover. A good decision. It meant he could learn how to look after a baby and he learnt to take responsibility. This was really important to me.
Before I had children I thought everything would be a nightmare. I pictured myself staying at home all day in pjs, massively overweight with dark circles under my eyes with a major mental health problem. I imagined that when we did go out, we would be wrangling our screaming kids into pushchairs with no time to ourselves. I also assumed the pregnancies and labour would be awful.
In reality, my life has improved loads in so many ways. I am more content so I sleep better, I am better organised, closer to my family and my partner. Both pregnancies were fine. First labour was fine, I couldn't believe it was so easy. Second less fine but not really terrible. I have plenty of time to myself which I value a lot more than I did. AND I'm fitter and healthier than I have ever been.
I had no parenting skills before having children and no 'motherly intuition' or whatever you call it. Having children was an entitely rational decision. I read books about sleeping and looked stuff up on the internet and did little experiments to see what worked. All very useful, in spite of people saying, "your baby won't be like the book," as if I was stupid. It's great to learn from other people and apply it to your own circumstances. With Number 1, I didn't go to NCT classes or baby groups and avoided other new parents to escape judgements and comparisons. A good decision overall, although now I'm more confident, I would go to them.
I realise now that as a non-parent, I was basing my judgement on what is visible on the outside when you see parents bickering and kids screaming out and about. Yes it can be difficult with children when you are eating out or when you are in shops, but that's not all the time. That's just certain moments and certain times.
When I was childfree (up until I was 37) all I ever heard was bad stuff too, but maybe that's because parents don't want to boast or make it sound like you are missing out. Because that would be cruel, especially as having children is such a personal decision. I don't go on and on about how amazing it is to my friends who don't have children.
Good luck, it might not be as bad as you think. It might even be lovely!