The pro that installed garage door recommended silicon. I bought a spray lube for garage door at Lowe's called 3-in-1 Garage Door Lubricant. I was told to avoid grease.
Chain or worm drive?
Either case, silicone spray is better than dry, but hardly ideal.
Grease a worm drive, and use motorcycle chain lube [or dedicated spray lube] on a chain.
Chain = just about any quality lube. Bicycle chain lube will work well.
Worm drive has a lot friction. Something with EP additive should be used.
Silicone is poor for metal on metal applications but fine for metal on plastic.
I use SL-10 from MPC which is an oil/grease combo with EP additives. Works great on both worm drive and chains, as well as the metal plain bearings on the doors.
One of the heavier bike chain lubes would probably work as well.
My manual stated not to grease my screw drive? I use PB Garage Door Lube (Big Lots buyout several years ago) on the rails. Garage door dude said to use WD40 on the springs -- to prevent from rusting (when replacing my springs a few years ago).