I dont really like any of them. I mean, I wouldnt put any of them in open view in a room thats not a dedicated gaming/hobby room. Some look better than others sure, but none Id really call pretty. The material used for the shell is often ugly, especially in consoles pre-6th gen. Basically, every console thats made of plastic and looks like it is not good looking, because the plastic look makes them look and sound cheap. 6th gen onwards the look and feel of the material gets better though and its less of a problem. Especially in handhelds. Handhelds get the better end of deal anyway as far as Im concerned, theyre often better looking. I like the look of things better when theyre more neutral, more plain looking and arent trying to scream how cool and edgy they are.
I guess the DSlite and DSi are the ones that fit most into that category, Id say those are the best looking consoles.