The odds are much better in single zero roulette than double zero roulette, also called American Roulette, for obvious reasons.
In games without la partage, you lose your entire bet if you hit zero, so la partage games like French Roulette are definitely the way to go. Casinos offer games with or without the “la partage” or “half back” rule, where the player only loses half their wager if they hit zero.
The most common type of roulette you will encounter is European Roulette.