Rats, smashed windows and slashed tyres — a Ryde councillor says abandoned vehicles are causing "absolute misery" for residents and is demanding action.