Footage shows the "horrendous" conditions inside a house in Walsall where the RSPCA found pets with rubbish and excrement piled high in what was described as a the "worst case" by an officer