Found myself in a similar situation so I do understand how you feel.
My DH and I split nearly two years ago and I met another man a few months after. He was a couple of years older than me but didn't have any children.
He was well aware of my family life (two DSS, eldest ASD) and said he didn't mind, etc. We were together for 18 months and he dumped me on New Year's day this year, telling me he couldn't do the 'whole package' - meaning couldn't hack the kids, ex-DH etc, I suppose.
My confidence has been shattered (he broke it off after 'kindly' pointing out where I was going wrong with disciplining my youngest!) and I don't know if I ever want to introduce my kids to a new man ever again. I don't want them to remember some string of 'mummy's friends' running through their childhood.
I totally understand when you say you're sick of making the best of it and when all you want is a happy family life. It feels like I'm always waiting for something to happen - does that make sense?
I'm generally happy with my lot and I suppose you just have to think back to what it was like with the Ex-DH. At least you're well out of that one. And 6 months of lovely sex to remember I suppose.
You're certainly not a fool for wanting it to work out. It's only natural to feel that way when you're in a relationship.
For my part I try to always have little events to look forward to - a girls' night out, going to get your hair done, etc. Would it help you to organise something fun to do for yourself? Do you have any babysitters?
Best Wishes