I have done this a few times in the past. I don't think it turns me on and I also feel I wouldn't like to have it done to me. One guy I know likes the warm sensation of it running over him. One of my lovers wishes to try it but he wants to make it romantic, if that is even possible.
I think I will question one of my friends later today and ask if there were any other reasons why he enjoys it.
All the times I have done it have been with the man in the bath and me over him. I have never had a problem with it smelling though I do drink a lot of water, though once I did it after a large amounts of beer. We where too drunk to notic smell differences but the booze did make me go for longer.