This is discussion archived from a time before the current discussion method was installed.
Essentially the entire Harry Potter series.
Characters like Remus Lupin, Sirius Black, Mc Gonagall
, and especially Dumbledore are respected and presented in a positive light. In Order of the Phoenix, the kids desperately need help from the adults in the final battle.
Zeta: It's more that Harry and his pals think they're useless, but this is constantly subverted and strands them in dangerous situations.
Someone added Harry Potter
Lots42: I remember the first Freddy movie as noteable for the adults -not- being useless...