I also hate working under the car or inside and not have enough light! Putting some long flourescents on the walls about 3' off the ground makes a HUGE difference. Try using the T8 bulbs/fixtures instead of the T12's. The T8's are much brighter in my opinion.
Also look into getting a PDR light.
https://www.autobodytoolmart.com/p-10863-13307.aspx I know there kind of expensive BUT man are they worth the money!!! Awesome for detailing, polishing working in the engine bay under the car.