Artist and director John Waters, known for off-kilter cult favorites as Pink Flamingos and Serial Mom, has been subverting common themes