I've heard 'Fuck' said in numerous non 18+ titles.
There is honestly nothing wrong with the word. If I asked you what was inherently wrong with the word, you could not find an answer. 'Its rude' Why? 'Its offensive' Why? Because society has told you it is? Do you do everything society tells you to do? Because of its meaning? So we should put the same stigma on other words like 'sex' and 'intercourse', among other numerous things (Seriously, it has a use for just about anything: http://en.wikipedia.org/wiki/Fuck). There is nothing actually wrong with the word itself, only in how it is used. When used in ways such as 'Fuck You', it becomes offensive. Its the same sort of thing where die, go and hole are not offensive, but combine them in the sentence 'Go die in a hole' and it becomes offensive. Using Fuck to try and offend someone is wrong, and should be punished like any other attempt to offend someone, but when used as an interjection or as an intensive, there is nothing wrong with it.
Some of the stigma against using Fuck as even an interjection or intensive may come from those with excellent English grammar skills, who may see it as a lazy interjection or intensive where the person who said it could have thought of a more creative word, but that does not actually denote anything actually wrong with the word.
Take into account here that I use the word often IRL when talking with friends, as many do, but if around someone it will offend we refrain from using it. Whilst I do not understand how it can offend some, or why it is offensive, and as such can only barely respect that point of view, I respect the fact that some do find it offensive and will refrain from using it around those people out of general politeness. There is, however, nothing wrong with the word itself, and I see no reason to actually get offended by it.