Excellent topic, Poojer.
Although there are tons of bands not getting radio-play today that can write a good road tune, nothing captures the whole package (broken down van, no money, long drives, fights among band members, nervous breakdowns and hijinks) like the "documentary" Hard Core Logo by Canada's own Bruce McDonald. A fake rockumentary about an aged canadian punk rock band striking out on the road for one last reunion tour. It's a hard movie to find, but well worth it.
The soundtrack is worth owning itself for the "bands" songs.
Rock n Roll is Fat and Ugly
Edmonton Block Heater
Something's Gonna Die Tonight
As a bonus, the CD also has The Ramones' "Touring", probably the greatest road song of all time..."Touring, Touring, it's never boring." Beautiful.