Almost half of drivers insist cameras exist to make money, with 52% claiming they are not situated in accident hotspots