Mechanical stuff you're looking at grease, oil, penetrating, or dry. I found this with a quick search for more info. Personally I've found white lithium grease to be the best general purpose one for my needs (squeaky hinges, drawer wheels) but it can be pretty messy if used in the wrong spots. For most fast moving things with fine parts (like a bike chain) I really like wax lubes but they can get gummy sometimes so silicone works well too.

For sex I prefer water based because it is easier on toys and doesn't make me fear for my life when trying to wash off in the shower after. It isn't usually as long lasting as silicone based but it can be 'revived' with some water or other fluids. Anal I prefer oil based (shout out to Boy Butter because the name and logo are ridiculous but it works amazingly) but it also damages condoms so like if you're not using an insertable go for the protection and silicone combo. For oral I'll concede that wd40 actually has a use case here.