A coroner has recommended sweeping changes to hospital procedures after an over-sedated psychiatric patient suffered a preventable death.