I am on exactly the same page as you, i HATE needles. I sat in EMD with a broken arm for 6 hours with no pain relief as i was too scared to have a needle when i was 18!!! (I have got a little better over time since i had to start putting needles in other people! but i'm still not a fan.)
Having said that, i have had acupunture quite a few times now and i can honestly say it does not hurt at all. Infact sometimes i feel nothing, sometimes just a little sting. The guage of the needle is SOOOOOOOoooo small. It is honestly tiny, smaller than a pin. Compared to a blood taking needle, which needs to be reasonably large so as not to damage the blood cells. Sometimes it feels funny, but NEVER painful.

BUT if you can't come at having accupunture than no harm in trying an osteo or someone who does accupressure.