Thanks to steam user HunterCZ122 who first posted this steps-by-steps to make this game works : -Download CnC-DDraw -Put ddraw.ini and ddraw.dll in the Apps folder in the game directory -Put WINEDLLOVERRIDES=ddraw=n,b %command% in the launch options

According to some reports the game may hangs when selecting, but I managed to load one of the included just fine

Game run fine once you put cnc-ddraw

Bonus : There is two tracks missing in the soundtrack for some reason. Thankfully people found a way to bring them back here https://www.gog.com/forum/simcity_series/how_to_get_the_missing_simcity3000_music