I'm biased, I've only ever used water-based lubricants anyway. But I'd like to note that I'm hooked on maximus and ever since I got it, I haven't wanted to try anything because it's thick and compatible with every toy.
There is no "best lube"- there are different lubes that are each best suited for different jobs.
Water based is the most versatile lube. I fuck with silicone cocks so water based is the lube I reach for most often. It won't damage toys and it will wash out easily.
Silicone and oil based lubes have serious staying power that makes them ideal for anal sex or fisting. They are also great for in the shower. But they will damage lots of toys and are harder to wash off.
Each type has positive and negative elements. It really comes down to what you're doing with them.
Water-based are very widely available and affordable, but I'm not terribly well-versed in this area. They're also compatible with anything (except sex in the shower/bath/other watery area)
I really like silicone lube (Pink Silicone is my favorite) and would definitely recommend it as a quality option (especially for anal), but silicones aren't as all over the place and as cheap as water-based.