A major scandal over red light cameras has erupted in Melbourne with thousands of drivers to have their fines paid back by the state government.