A decade-long lack of investment in major roads projects has caused a major traffic jam in Cork — literally and figuratively.