“Avenue Q” is a counter-cultural poke at its inspiration’s incessant optimism. Regardless of the puppetry involved, this ain’t kid’s stuff. Both in song and story, the musical is profane, bawdy, and occasionally raunchy.