What is the best kind of oil to use in a 1995 Vulcan 800?

While any kind of "best" answer is debatable, you should get an oil designed specifically for motorcycles, and especially not one that is designed with additives for greater lubricity. This is because your motorcycle's clutch uses the oil and there is such a thing as too slippery.