I use Motul “Factory Line” Chain Lube. It sprays on fluid and clear, but dries tacky and waxy. It stays on pretty well, but still gets dirty, and still gets a fair amount all over the underside of the chain guard. Just the nature of the beast. I know a lot of folks use Tri-Flow, but I haven’t so I can’t comment.
Sounds like what you have may be a bit too “fluid”.