Dissipative Optomechanical Preparation of Macroscopic Quantum Superposition States