"When my Dad died I discovered he'd told my sis he wasn't my dad."
I presume your sister told you that? Three possibilities;
- She's making it up to hurt you - why?
- He did say it, but he was mistaken (because he thought your mum had an affair, judging her by his philandering standards)
- He did say it, and it is true.
He is still your Dad, because that's the role he played in your life 'til the day he died. Is he your bio-dad? Well, you need to decide whether you want to establish that or not. You say you look like him.
"I know that my mum had been in love with the husband of a couple they knew."
Ask yourself if you know-know that, or whether you assume-know that, or whether this is something you've been told with no proof. And even if she had, would she have acted on it?
Consider this possibility of why your dad mistakenly thought you weren't his child: Could the multiple miscarriages have played on your dad's fears? It's common for philanderers to presume everyone else behaves as they do - so much easier than admitting to themselves that their behaviour is wrong and they should change it! So, fearing that, and a pregnancy not miscarrying, he may have brooded on the possibility that this pregnancy was 'different' from the others, and the 'difference' was another man's sperm.
But at the end of the day, he treated you as his child, didn't he? So in the (in my opinion, not that likely) event that he's not your bio-dad - do you want that possibility confirmed? If you do, then I'd see if I could DNA test against another family member - not your sister. I'm considering that maybe she's not your dad's daughter.