To see if you like it, why not try out a live cd? You can boot off the cd and play around with it without ever putting anything on the hard drive. Some options include Knoppix, SUSE live-eval, and MandrakeMove.
If you like it, some good installable newbie distributions include Mandrake, SUSE, and Xandros.
Nowadays the most common distributions have graphical installations, and its possible to use the system without ever encountering a command prompt, but of course you have complete access to all the power of the unix based shell. Yes, most of the commands you are used to will work, but for the most part you'll probably be using the GUI.
SUSE is my favorite general-audience distribution; it's easy to install (really a breeze, just keep clicking next...), supports everything, and comes with just about any program you'd need, from Office compatible software to music players. Very nice. I remember that Mandrake came with tons of software as well ("tons" as in three different audio players, a digital editing program, multiple video players, TWO complete suits of office software...).
Hope that helps!