With a girlfriend, once every so often is great. Especially if it's inappropriate and there's some roleplay involved. But I like to have to woo a girl and put in some effort, otherwise what's the point in a relationship.
With a friend who you've wanted for ages then the more up for it the better.
With some girl in a club or wherever some restraint would be appreciated, it's all in the chase.