Northern Ireland’s roads are so bad that some motorists will soon need moon buggies, an MLA has warned.