I am completely and totally obsessed with Harry Potter, so this review may be a bit bias but... I LOVED IT! If you haven't seen HBP yet, you definitely should. While there is a bit of drinking, it's not a huge deal and barely prominent except for in one scene. Harry, Ron and Hermione drink butterbeer, but butterbeer contains very little alcohol (as said in book four) and so it's not a big deal. Drinking is only prominent in one scene, when a major character is poisoned. Ron is often caught staring at Hermione's lips (laughs gleefully) and there is a lot of flirting between the two, but then Ron snogs another character, leaving a heartbroken Hermione (played excellently by Emma Watson, who is really at her best in this movie) to sob with Harry, who is also pining over his crush. It is a very, very sad scene (or at least it was for me, because I am in love with the idea of Ron and Hermione) and made me a little misty, so it might upset younger children, who will not understand exactly what is going on, but will be upset that the female lead is crying. Also, there is a blood curling scream that comes out of nowhere, which can be a shock to people who have not read the books and didn't know what was coming. During a very dark scene, extras are shown in a corridor making out and smoking something. Two major characters (NOT teens) get very drunk, one to the point of passing out, but it is done comediclly.Kids might be frightened by a giant, dead spider. Teens start relationships, flirt, end relationships, cry over relationships- overall, HBP is more sexually charged then the other Harry Potter movies, which is wonderful for adult and teen viewers such as myself, my mom, and my grandmother, but not so much for the younger kids. As for violence, well, there's a disgustingly bloody scene, but the character is Healed. The worst part is when disgusting skeletal creatures kind of attempt to kill Harry... it's pretty gross, definitely something I'd have my kid close its eyes for if I had one. Another unsettling part of the movie would be when a huge character dies. It is drawn out and very, very sad. All of the characters cry and are devastated. However, this is nothing compared to what I presume will happen in the seventh movie, because in the seventh book characters start dropping like flies. So, all in all, bring your older tweens, but keep seven year olds away from your TV and use your own judgment on your eight year olds. It's definitely fine for 9, unless you don't want your nine year old to see a lot of kissing and teen relationships.
What other families should know
Too much sex
Too much drinking/drugs/smoking
Great role models