You are correct, Triflow have various types of oils and greases. The one recommended for sewing machine's is an oil in
a bottle, and its' much like you know the regular sewing machin'e oil. It has added teflon and various clever solvents, and it's a notch or two smoother than the regular stuff. The spray can stuff and dry lube variants are for different purposes. Another oil that's just as good is Finish Line Ceramic Wet Lube. This brand has a good selection of lubricants too; the only one that's good for vintage sewing machine's comes in a transparent bottle with
a gold cap. The basic oil is nice too, the most important thing is to oil regularly.