I use it as a full desktop, with dual monitor, and desktop effects, but honestly...
if you don't EVER want to see or use a command line... you probably aren't going to like it.
As user friendly as it is, the command line is like the life-blood of any linux. There are GOING to be times when you need to manipulate things with it directly. The Ubuntu community does make it quite easy to do things using the command line though. (step by step instructions)
I was also intimidated by the command line initially and have learned it over time. Once you start to learn a few tricks with the command line, you really do see why people use it. You can do lots of things much faster (like rename files)
note: I really do think it is quite easy to use, especially if you know a linux guru who will initially set up all the hardware for you (which is the hardest part)
My mother (who still doesn't grasp the idea of tabbed browsing and often needs my help to compose an email using gmail) uses ubuntu on her computer every day and thinks it's worlds better than windows.
Go figure