Thanks for that steviem

hope it helps!
I'm sorry but I can't really answer your lightroom/aperture question as I've only ever used PCs for this sort of thing. Just from a quick bit of reading around there are a few plus points for both it seems;
- Aperture ties in very closely to iPhoto so if you have your personal photos stored there it seems you can jump back and forth easily;
- Lightroom however has deep intergration with Photoshop, makes it very easily to "round trip" to PS CS6/elements for pixel-based editing
- I'm not sure if Aperture makes use of DNG. As I said above my workflow is based all around that now so I'm comfortable with it.
I guess the one question you'd need to ask yourself is what isn't Aperture doing for you that Lightroom could? Both seem to be similar programs. Either of these programs can become resource hogs over time so a RAM upgrade or possibly an SSD for your OS and programs may be a better spend of money, and a lot less time than learning a new program! I personally have an SSD for Win7 and my most used programs (of which Lightroom is one) and 12GB of RAM.. I'm not trying to sound flush (this build has taken over two years of buying bits here and there and sort of planning upgrades, hence AMD processor as Intel change their pins every generation it seems! lol.) but you'd be surprised at the increase in speed a good SSD will get you
As far as my editing workflow goes mine is pretty specific to weddings but I'll give the outline of it:
- Once all the original RAWs have been backed up as I mentioned earlier I import a .gpx file (GPS tracklog file) for the day's wedding. This comes from a great, and free, iPhone app called myTracks which I have running all through the wedding day. I don't tend to "autotag photos" because if you've ever used a GPS tracker before you'll probably find that it does jump around the map quite a bit if you have a weak signal even if you're just stood in one spot, in a church say, so I use it more as a reminder of everywhere I've been rather than having to find post codes of venues and such then drop the photos on the map to those locations manually.
- LR4 makes this really easy to do with a smart collection. Use the "Without Geotag" metadata field and as you drop things on the map they'll disappear from the filmstrip leaving you with only the untagged photos (nice to see your workload getting smaller as you do it!)
- After all the shots are geotagged I keyword them. I have 5 categories of shots for a wedding (Bridal Prep, Ceremony, Reception, Detail Shots and Bride & Groom) which every shot will be assigned to (using the grid view this is easy to assign a single keyword to a load of pics at the same time).
- I tend to add others like 'best man,' 'bridesmaid,' 'candid,' 'B&G chosen shot' for those photos the couple specifically asked for and 'cake cutting.' Basically just trying to add as much detail as possible to track down shots and make life easier at proof meetings when the bride asks "didn't you take a shot of X with Y when they were talking to Z?!"
- Once the keywording is done I go through the whole day and assign 1 star to my "chosen shots." These are the ones that I want to process further and think that
could be album quality.
- I make a smart collection for the wedding with two criteria; "filename includes "INVOICEXXXX"" (for their invoice number) and "image has 1 star or more"
- From this smaller collection, I run through again and assign 2 stars to any shot I think stands out for that wedding (I always try and get at least 10 or so different shots that makes that wedding, I've had bride and grooms posed in streams with colourful wellies or kissing on the balconies of their bridal suites if it's at a hotel.. stuff like that)
- I then edit all one star or greater images (paying particular attention to 2 star images as I want these to look their absolute best). Lightroom's lens corrections are applied to EVERY image because it's fantastic, who wouldn't want all the distortion taken out of their shot?! Tone curves are great and PV2012 makes shadow/highlight adjustments so easy to use it makes the time go by a lot faster!
- Edit any shot that needs it in photoshop (street lights coming out of their heads, coke cans on the lawn of the venue, that type of thing that content aware fill works great for)
- I assign a green colour label to all the shots that I've edited to completion
- Yep, you guessed it, a smart collection with "colour label IS NOT green" is set up so I have a countdown of remaining shots to edit, helps if I take a break during!
- Once all that editing is done I go through the 2 star images (using another smart collection, invoice number and 2 stars or greater) and give 3 stars to the 3 or 4 shots I want to keep for a "Best of 2012" style portfolio album
- Once you're at this stage you have all your shots processed, your chosen one star pics ready for upload to the couple's online gallery with the 2 star shots given pride of place.
- A smart collection of "capture year 2012" and "3 stars or more" set up for your best of the year shots
- You can then save all the metadata to the files and backup as I mentioned earlier.
I know this is very wedding specific but it can mostly be changed around by just choosing different keywords/smart collection titles
I shoot my personal photos in full jpeg rather than RAW, I rarely NEED to rescue a holiday snapshot and quite like that to be honest. I don't like a few holiday snaps to start feeling like work back in lightroom. Having said that I do keep my personal shots and pro shots in the same lightroom catalogue for convenience mainly. My working image drive folder structure looks like this:
1) arht photography images / lightroom catalogue backups
2) Personal/Professional
3) folders by year
4) folders by event (birthday/italy trip) for personal/couple name for professional
** A quick not, I don't convert my jpegs to DNG. They're already smaller than the raw DNG files and have the same advantages of being able to contain the metadata within the files. Jpegs are also publicly documented so archiving shouldn't be a problem.
I don't run through my personal photos with the same fine-toothed comb, but I do still stick to the same convention (so 3 stars for portfolio level work, 2 stars for stand out shots of the holiday) because it makes it simpler when it comes to sorting into smart collections. For example I have a smart collection for great family portraits set up as "keyword includes any of *all my family members names* and 2 stars or greater" so as I assign stars it starts to fill up and as and when I want to get stuff printed for frames and stuff it's easy to find. My personal photos are stored on my internal working drive and get backed up to my weekly "backup everything" drive, I don't burn disks or store on other drives apart from the portable one in my camera bag (this one is basically a mirror of my PCs working image drive).
It's just occurred to me that you might not know what a smart collection is if all you've used is Aperture :S It's basically a virtual collection of images based on filters that you define and they update automatically so if you take the stars away say in one of my collections above then the shot disappears from the smart collection (it isn't deleted from the library though, smart collections are all virtual).
Right, here I've gone and written another ridiculously long post, sorry! Hope it helps though steviem
What's your process at the moment? Do you make much use of the "places" "faces" and "events" filters in aperture/iphoto? It's something I've been quite jealously eyeing up from the PC side of the wall!