Bedford care professionals focused on keeping a man with mental health problems in his own home at a cost to his health and welfare, an investigation has found.