I find that most people I talk to had positive opinions of the late queen, but as you said are apathetic towards Charles at best and disturbed by Andrew. Prince William seems to be highly regarded though.