Context is far more important than profanity. Saying 'please' in the right way can be highly offensive, depending on context.

Despite being 'the magic word', there's nothing magic about 'please'. It's just a word. It's the context it's used in that communicates consideration or not.