Over my decades of working as a bicycle mechanic, I have found Rock n Roll lube to be hands down, the best lubricant for a chain.
Gold is for all conditions. The standard.
Red is extremely dry. It's the cleanest, but also must be reapplied more frequently.
Blue is for extreme conditions like rain. It's is the wettest and stays on best in rainy weather.