If you wanted to provide a refuge for the amateur then you are playing towards one of your weaknesses. The camera that I buy at BestBuy is not going to have instructions ons on how to use it with linux. If your not targeting teh professional you have already lost.
System resources are not much of an issue anymore, the amount of memory most window managers require compared with other applications is fairly negligible even with "heavyweight" Window managers. Unity+Nautilus together are using ~400MB/8GB on my Ubuntu 12.04 PC.
The hardcore "lightweight" WM fans only need a way to tile their terminal and XMonad already provides that.
With Ubuntu 12.04 every digital camera I've tried has just worked. I plug it in and and offers to import all of the photos for me straight away, no need for instructions or drivers.
Getting professional software would require either persuading enough of the big names in the business like Adobe , Steinberg , Avid etc to port their stuff to the platform or it would require Gnome contributors to create full equivalents for all of these programs from scratch with their already stretched resources so very impractical.
Creating an iPhoto type front end for GIMP seems a more achievable goal.
I don't think ~400MB for a window manager on a dekstop is a big deal in 2012 and being able to compose your desktop using javascript is a breath of fresh air vs using old arcane APIs. When you have as much excess horsepower as you do in a modern PC (for most tasks) it seems wasteful not to use some of it to make your life easier.
Media creation software doesn't have to be high level pro stuff. Having Gnome ship with software that is great for amateurs who want to make youtube videos, mess around with filters on digital photos, or record themselves jamming on their guitar would be a great start.
The existing software like GIMP would certainly be powerful enough for this, the main work would be in reworking it's difficult UI.