I believe in moderation. Simply throwing it (and other cuss words) out there all the time seems like an attempt to shock rather than provoke thought. Use it effectively, and it's a decent tool.
On the other hand, some music needs it. Would "Killing In The Name" be half as effective without...