The desktop is quite variable. You can run a variety of window managers and within gnome or kde you can customize many features like window decorations, buttons, window textures and such... Try kde-look if you use kde. I'm currently using the mosfet liquid theme with the baghira window decoration which gives an aqua-like look and some nice crystal buttons and stuff...
I don't much like transparent windows, so no help there
