Macroscopic, many-body self-trapped and quantum superposition states of the gaseous double-well Bose-Einstein condensate (BEC) are investigated within the context of a multiconfigurational bosonic self-consistent field theory based upon underlying spatially symmetry-broken one-body wave functions. To aid in the interpretation of our results, an approximate model is constructed in the extreme Fock state limit, in which self-trapped and superposition states emerge in the many-body spectrum, striking a delicate balance between the degree of symmetry breaking, the effects of the condensate's mean field, and that of atomic correlation. It is found, in both the model and full theory, that the superposition state lies energetically below its related self-trapped counterpart even when many configurations are involved. Noticeably different spatial density profiles are associated with each type of excited state, thus providing a rigorous justification for approximate descriptions of high-lying excited states of the BEC.