I'm gonna go generation by generation. I'm sticking to Domestic stuff, for simplicity:
1) the 2600. Most of its variants are nice looking, especially the Vader and the Junior. the Odyssey2 was pretty nice too, but the keyboard could be cooler.
2) most of the consoles of this generation have those awkward number pads, disqualifying most of them. the Vectrex is the best of them.
3) In spite of its software, the 7800 is the nicest looking of the post-crash 8-bit consoles. The SMS is slightly awkward, and the NES was deliberately made to look like an appliance.
4) the first variation of the Genesis was really cool. the Turbografx-16, by comparison, was awkward. the SNES is nice, but the model 1 Genny is cooler.
4.5) The TurboCD just made the already awkward Turbo, more awkward. The Duo was much cooler than the Turbo, as well as the Genesis. the Genny model 1 CD has its charms [bigger=better!] but isn't as cool as the Duo. The 2nd variation of the Genesis wasn't as cool as the first, and the CD add on didn't help much.
4.75) the Genesis 3 is pretty cool, just for it's PC-E like size. the 2nd model SNES makes it a bit cooler.
5) the Saturn is much sexay. Most other consoles of this generation are either awkward (Jaguar, n64) or plain(playstation, 3d0). the 32X with a model 2 Genesis is pretty nice, but either of the CD systems make it awkward.
6)the Dreamcast was nice, but could have been a bit more exciting. the Gamecube is cool looking, particularly the (Japan only) Orange cube. Both the original XBOX and the Playstation2 are awkward looking to me.
7)I hate to admit it, but the original ps3 is pretty awesome looking. I think that Sony was trying to make the original look like a Duo. the newer model isn't as cool. The Wii is also pretty cool. the original 360 is pretty plain looking, but the new model is cooler; but it's only a little nicer than the new ps3.