I caught the same episode.
If the clear coat has faded, you can still try to do some reconditioning of it. If it is rough you can wet sand it smooth using some 1500grt sandpaper, then medium cut, polishing, wax. An automotive paint supply shop(or paints supply store that sells automotive paints) should be able to tell you what products you need, and sell you everything you need from the compounds to the polisher. A standard electric sander isn't going to be helpful for polishing. This
polisher form Porter/Cable would be a good investment, either to try first to see what you can do w/what you have now, or for during the finish work after you paint. It has a built in pressure sensor to prevent you from burning through the paint when cutting/polishing.
Rattle Can
Duplicor paints are usually a close match depending on your color, the newer paints are better matched and more colors to choose from, not so much for colors from the '80's and early '90'.
Some dealerships used to be able to order matching code paints in a spray can, but I am not sure if any do anymore, it has been about 15yrs since I ordered some for my '90.
I did find automotive coded paint in a spray can when looking for paint for my project Supra(need to paint a fender and bumper skins), it ran $20/can
It wasn't shown on Wheeler Dealers, but you usually need to sand rattle can paint to get a smooth factory looking finish, then and follow it up with polishing/waxing especially along the edges where the new paint meets the old.
Spray gun
Duplicor also makes their
Paint Shop series of paints that aren't as toxic as traditional automotive paints. These paints do not require an air filtering paint booth and can be done in your home garage, but you should still invest($20) in an automotive paint sprayer mask. The masks are good for about 45hrs or one yr, since they don't have replaceable filters. The duplicor paint comes ready to spray, no mixing, though you are limited to their current line of colors, plus 3 more(according to their forum) slated to be released soon. It is lacquer paint, so don't expect it to last as long as traditional automotive paints. The paint runs about $20/can, you would need about $100 worth do do an entire vehicle(1 can of primer, 2 cans of base, 2 cans of clear). I painted a 7' Toyota truck bed trailer with it 3 CA summers ago and the clear hasn't faded at all, unlike most on the paint forums had claimed. The clear was a bit soft at first but it has hardened up and I can't scratch it any easier than oem paint.
Before doing any painting, I would buy a clay bar to smooth out the paint, a bottle of Zymol car polish(deepens the color, gives it a wet look) about 3 coats should work, followed up w/a couple of coats of a good wax to see what you have. This would be the cheapest route, and shouldn't run you more than about $60. If you wanted to try wet sanding the clear, I would try it on the roof first, where any mistakes are less likely to be seen.
You might also be interested in this
Roll-on-paint job using marine paint. There is another roll-on-paint post on a Mopar site, the guy used a paint called tremclad which isn't available here in the U.S., the closest thing he could find was rustoleum. I tried his process an old hood but couldn't ever to get it to harden right, but I also don't think I ever really got it thinned enough either. I think the marine paint would be the better way to go.