Provide a theoretical discussion on the concept of quantum superposition. Compare and contrast the Copenhagen Interpretation and the Many-Worlds Interpretation regarding the mechanism of wave function collapse upon measurement. Analyze the theoretical implications of the Schrödinger's cat thought experiment in the context of these interpretations.