A new report into care homes has found what has been described as "an appalling lack of care" in a large number of homes.