In reply to Tricadam:
No, you are not being weird.
And comments about nice soft pads are not helpful.
Get a good bouldering partner: someone you trust - preferably someone who is already experienced as a spotter. Knowing that they're watching your back will give you some confidence. Their job is not to catch you if you fall off, but to direct your fall, make sure you don't hit your head, etc.
Start by jumping off from a low height, then gradually increase the height.
Eventually with some practice and experience, you will get more confident. But there may still be situations when you'd rather not try certain moves... without a spotter / at that height / at all. Do not view that as a failure! Everyone has their limits - don't judge yourself against other people.
A winter of bouldering with my now husband had me confident to try the higher harder problems (still on the easier circuits, but hard by my standards). But then I got laid off with a dodgy elbow, and have never got back into it. A big part of that is that I lost the confidence I'd gained in trying harder moves at height, and as husband has been injured himself he hasn't been into bouldering so much.
But even if you don't actually boulder that hard, you will find it beneficial for routes in terms of technique.
Hope that helps!