It depends on the man, the dildo and his ability to handle it.

It can be very attractive, but it can also be a total turn-off. I mean, for example, sensual play with a bit of dirty talk and moaning can be very hot. But this exaggerated "give it all you've got and do it as hard as you can", combined with overacting like in some bad porn movies, is a total turn-off for me.