"I know i'm just going to get more replies questioning me, but my question was if they were optional, and I got my answer so I wont be addressing why I don't want one as thats not really anyone elses business." very defensive there OP. You're right it's nobody's business, but if you take that attitude with the health professionals then it may well raise red flags for them.
Of course there are good and bad health visitors just like there is good and bad in every other profession, however you're not going to know that until you meet them, and as a first time parent you really have no idea whether or not you might find them useful.
I had very little input from my HV - she came round once, and I went to the weighing clinics after that, arranged all my own vaccinations etc, the surgery also had a nursery nurse who was far more involved and hands-on than the HV anyway. The only intrusive involvement I had was when a new HV came into the area and rang me to say that she thought she should visit me since I was blind and she needed to know I was coping. DS was three at the time. I asked very bluntly whether she was visiting all the new mums in her area or whether me having a disability should somehow single me out and if so, why, since I'd never had any involvement with services before. She couldn't answer me. I let her come round to satisfy her curiosity and she went on her merry way never to be seen again.
I would wonder whether someone who has no experience of being a parent yet Was opting out of HV involvement because they didn't want to engage with medical services for their child, would perhaps also be opting out of vaccinations etc based on what they think they know about the process....