First, don't judge Linux based on Ubuntu; they are not synonymous. If the Unity interface is too different and/or the lack of Flash and media codecs (MP3, DVD etc) is frustrating, try something like Mint.
Second, expecting Linux to act like Windows isn't reasonable; no one would have bothered developing or using an alternative OS if they were happy with the existing one; they have different underlying approaches to how an OS should work, and most of Linux's strengths lie exactly in where it differs from Windows. The same can be said of Apple's Mac; it wouldn't be a success if it's aim was merely to ape Windows.
A motorbike and a family sedan will both get you to your destination, but you can't drive one like the other.
Lastly, Ubuntu and it's derivates like Linux Mint, Zorin, and Pinguy are considered "noob friendly" exactly because there is little or no need to bother with terminal commands for almost all general use cases. At the most, when troubleshooting a problem you have to copy and paste commands provided by Ubuntu's help pages or forums, and IMO that isn't asking to much of a user is search of a solution.
Some resources:
http://linux.oneandoneis2.org/LNW.htm
http://ubuntuforums.org/
http://askubuntu.com/
http://www.psychocats.net/ubuntu/
http://www.webupd8.org/
http://www.tuxmachines.org/
http://www.omgubuntu.co.uk/
http://distrowatch.com/