I've gone and made a 90 frame video intro for a Youtube series that I might or might not start. I've used the name "Grokology", as it is my domain name, and my minecraft username.
Here is an early test render of one of the frames. There have been many tweaks since then, but the effect is mainly the same.
I like to play with the Gimp, image editing software for Linux, BSD, Mac,Solaris, and Windows. I don't have any experience with Photoshop, but I've heard people say that you can do pretty close to anything in the Gimp that you can in Photoshop, except that there are a lot more plugins for the latter. Here are some of the images that I've done over the years, in no particular order. Edit: I added a few that were done in Blender as well. I hope it doesn't slow the loading too much!