So here is my dilemma. In 2008 I finally got around to buying myself a DSLR, and since then have accumulated ~80k of images. With my iPhone 5 being my daily point and shoot (and the iPhone 4 previously) I've got another ~5k of images.
The DSLR images are a mix of vacation snaps and hobby photography, mostly shot in RAW. The iPhone pics are the daily snapshots. For awhile I was using my PC with Picasa, then LightRoom and had things nicely organized in folders. It took me a while to get used to LR's concept of collections and albums which obfuscated the underlying folder structure, but eventually I gave up on the folders and relied on LR default import location. I have two of these import folders, each with about 25k files in each.
Then I got a MacBook Air, and preferred using that for my photography. I played with Aperture, then settled on Lightroom again, but on the Mac. The issues and disorganization I had on the PC, got duplicated on the Mac.
So now I have created a nightmare for myself. I've got photos all over the place, with backups of backups complicating things. Both my MacBook and PC have been reformatted a couple of times so my LightRoom catalogs are all messed up due to files not being where they should. To complicate things more, I have tonnes of duplicate image file names due to the camera starting numbering over with each new SD card. I also have lots of duplicate images with DIFFERENT file names due to copies being created for editing.
I don't care about the LR catalogs, I'd like to start over from scratch with the catalogs on a portable drive that both the PC and MacBook can access. That will be my primary image storage location, with a backup onto my home NAS. I will mainly use my desktop PC, but want the option of dealing with travel pics on the MacBook Air while on the road.
I need some suggestions on a workflow to manage the bloat. I don't think I can do it in LR alone, I'd like to leave LR for the hobby photography - the images that require fine tuning. I'd like a utility that can allow me to view all the images across multiple devices, including the RAW ones, and allow me to sort through duplicates based on image properties as well as file name. I'd like to create folders for collections of images (vacations, events etc) for the daily snaps, non LR stuff. Finally, for the keepers, I like to have them available in iTunes so they are viewable on Apple TV, iPad etc.
This is my New Years resolution, meaning I want it resolved by New Years. My other New Years resolution is to really get back into photography again, and that means actually going out and taking pictures. But in order to do that, I've got to develop some good photo organization habits, and get rid of the backlog.
Don't get me started on the ~100 hrs of random video files as well...