As I recall there was an offical patch for SimCity 2000 released on Aminet. When thats installed you hold down the shift key after starting the game and it will bring up a window asking what sort of screen you want to run the game on.
I sure Ive had the game running fine on my PicassoIV in 1024x768.
