Multiband theory of quantum-dot quantum wells: Dim excitons, bright excitons, and charge separation in heteronanostructures