The only aerosol can chain lube that I've ever used that was even close to being worth what it cost was JB chain lube.
Its not cheap but it stays on the chain and chains last longer with it than any thing else we've tried.