It depends upon how good he is at it.
I never enjoyed it before my current bf (other than when I nursed my 2 daughters, but that was a different kind of thing). Before him, it really bugged and bored me! My current bf has a way of making the experience rather exciting and erotic for me though.