Electric cars are expensive and heavy but can apply massive torque and acceleration; Musk was brilliant to make Tesla a sport luxury brand. Battery electrics are hopeless for cargo transport or distant travel, and likely not cost-effective or appealing for local transit outside the sport luxury niche.

I think we might see some diesel-electrics in the future for cargo shipment (ie the system most trains use)

Hybrid is fine, you're adding a lot of weight and cost for fuel savings but they are probably ideal for taxi services and other commercial city driving with low cargo requirement and high stop-and-go usage.

Gasoline is easier to combust than diesel, making it ideal for passenger cars and motorcycles (ie high RPM)

Diesel has higher energy density than gasoline, making it ideal for cargo & heavy machinery (ie high torque)

Hydrogen is quite unattractive. It embeds in steel and weakens it over time, it has to be produced from some other energy source, and it has to be compressed at great energetic cost.

Ammonia is a more attractive produced fuel, currently not as cost-effective as a fuel as gasoline but perhaps with new processes (lithium salt method) and more efficient electricity (uranium fission) it could be competitive with naturally-occurring carbon biofuels.

Ethanol is quite unattractive. It is generally a natural biofuel (oil & gas) byproduct in that it is produced via ammonia produced from carbon biofuels. Inefficiently diverting foodstuffs to fuel drives up the price of food without really making fuel any cheaper. The current trend of watering down gasoline with ethanol in the US is simply nonsense.

In any case, CO2 gives us a greener, wetter, more tropical world and we are far, far closer to an ice age than any sort of catastrophic warming event. Animal life flourished during eras with 1,000-2,000ppm CO2 and our present 400ppm is far closer to mass extinction at 150ppm than to historically fertile levels. So drill, baby drill.