The main difference between water-based and oil-based fog machines is the type of fog they produce. Water-based fog machines create a white, quickly dissipating fog, while oil-based fog machines produce a denser and longer-lasting fog. The choice between the two depends on the desired effect and the venue size.