This is what I did...
I'm a Mac user since 1994.
The use of certain apps varies according to specific needs or desires. This is what worked for me.
I wanted to have all of my photos (about 30 GB for 30,000 items) available on all of my devices and available from any browser in the world, without having to manually copy them, and for as long as I wish (which, for now, is forever).
I was lucky enough to buy the 80 GB plan from Google BEFORE Google Drive came out, so now I have 85 GB of storage space in Google Drive, for USD 20 a year (Google charges USD 4.99 a month for 100 GB now, and USD 2.49 a month for 25 GB).
I created a folder named "Camera" in my Google Drive folder, and inside that folder, folders with years + months, like "2012-08".
I use the Picasa software version for Mac to import my photos and videos in any of my Macs. It would be great to have the videos also uploaded to Google Drive, but the file sizes are too large and would fill up the 80 GB very fast. Therefore, I import first into a local Mac folder, then select the photos and copy them to the corresponding Google Drive folder (eg: 2012-08).
How do I know the photo's dates? Because, before moving them to the Google Drive folder, I rename them to the EXIF date, with a software named "A Better Finder Rename", to something like "2012-08-15_14-02-21.JPG". If you, like me, have various cameras (or your wife and kids have), and you want to distinguish between the ones you take and they take, you can also make the software add text at the end of the file, like "2012-08-15_14-02-21-iphone4s-charles.JPG". I don't even have to open the software to do this, because I previously make ad-hoc droplets that do this automatically (this has to be done 1 time within the software, and it creates an APP which you save to any location in your hard drive, or even the Google Drive folder so it's everywhere!).
I also use the Picasa software to upload my files to Picasaweb, for which I also have 80 GB. But I don't upload in full size, only 1600 px, as I already have the full sized images stored on the Google Drive, which can also be downloaded or shared from there, if you were to need the full size picture accessible from anywhere in the world with a browser. As a matter of fact, there are apps for iOS, Android and BlackBerry to access your Picasaweb, so you actually can browse all of your photos from any device, as long as you are connected to the Internet.
And, I also use the Picasa software to manage all of my photos (make albums, prints, collages, email, etc.).
The only other software I use is XnViewMP to losslessly rotate some photos, because Picasa, iPhoto and others don't really rotate the actual photo, they change the "Orientation" EXIF data, which is readable by some OS and softwares, but not all. I do this AFTER I copied my photos to the Google Drive Folder, but you can do this before, too.
Regarding videos, I have an external 1 TB portable 2.5" HDD where I save them, as well as my photos, and I also have a 1 TB portable 2.5" HDD for backup of this, which I keep safely hidden somewhere inside my house, and I only use it to backup the other drive (never for anything else). It would be great to upload every video to Picasa, as it is free up to 15' each (enough for me), but it would just take ages to upload every one of them, so I'm not doing it.
Once a year I also save my photos to 8 GB Micro SD and keep those in a sealed Ziploc bag in a box with stationary (just in case I get mugged at my house and they steal all of the electronic stuff, and Google just so happens to lose my stuff or something).
Hope my case and experience helps.