Should I get a lighted extension cord?

Yes, get the lighted end — the power drain is negligible and the heat isn’t a problem. The real benefit is safety: you can tell at a glance if the cord is live, which is useful in a garage, basement, or holiday lights. The light doesn’t change the fire risk from overloading or damage.