Well, if you like what you saw in that screenshot, you probably wouldn't like Red Hat (Fedora) as its default look would be too "businessy" -- also it defaults to GNOME, and a special Red Hat theme called Bluecurve has been applied to KDE by default, making it look and feel more like GNOME.
Slackware is very neutral when it comes to GUIs and desktops - you can install any combination of anything. Heck, X is optional.
Mandrake defaults to KDE -- its look is vanilla by default (ie: it will look very generic, and non-personal) but it is easily configured. Mandrake also has very good GUI tools, but for some weird reason they're GTK+ based, which is what GNOME uses... so it's a bit of a mismatch for Mandrake's default KDE desktop!
Then there's SuSE, which also uses KDE by default, and uses a GUI setup tool called YaST, which is Qt based -- the toolkit KDE uses, so it blends in well with the desktop.
So, your question is very open-ended. It sounds like you like KDE, but if you're all about looks, you may want to take a look at this thread: http://www.linuxquestions.org/questi...threadid=26643
which contains links to many users' desktop screenshots.