Some will, some won't. (And there are plenty of straight men who'd enjoy it - it's a woman they'd be having sex with, not a man...) The only way to know is to ask.
Letting him pick the size and shape may well help, and silicone ones are nice than say rubber (hard to clean) or plastic (hard). You also want a decent harness rather than the disastrous elastic straps that A* S* shops have been known to sell.