Fed-up residents have reported vomiting, watering eyes and trouble sleeping as a “horrendous” sewage smell hangs over their neighbourhood.