While I would generally agree, in this specific instance, due to the methods used by Autism Speaks, much of the awareness has been very negative.
Remember this.. You cannot get acceptance without awareness, but you can get awareness without acceptance. Basically, awareness is important because it makes acceptance possible. Not saying to settle for awareness, just don't shrug off it's value.
Fortunately there are some other forces out there providing awareness too, but that ad I linked in an earlier post is pretty indicative of the nature of 'awareness' Autism Speaks tend to aim for. Unfortunately I can't see that particular kind being helpful at all.
It also unfortunately leads to a double bind situation for many of us on the spectrum, who because of the extreme and unpleasant depictions often get dismissed by others as not being autistic enough because we CAN speak for ourselves. So either we can't speak and must defer to others, or we are dismissed as being too functional and thus not really autistic. This is one of the arguments often used to explain why an organisation like Autism Speaks have no autistics on the board.
As you did mention from the show Parenthood, I don't think that was negative, and that sort of thing is okay with me.
There are some good and neutral depictions out there, and I would love to see those supported more.
This is one of my biggest reasons for so strongly voicing my objection to Autism Speaks. Because of their size and visibility, they soak up the vast majority of well intentioned donations to help autistics.
Then they produce all the negative depictions that harm us.
Sorry for the ranting, but seeing donations of good intentions actually work against those intentions really upsets me.