@ PUG:
I found the Beta Version of Lightroom on Adobe's website. I fell in love with it instantly- save for some hiccups with the software. I believe it's available now for $199 as a special. I've played with Aperture, but haven't gotten a good feel for it yet- It might be a better match for my computer as well.
Lightroom works very well with RAW; I only shoot in RAW- unless it's an ebay photo or something. As you can tell, I'm big on post-processing and tweaking the curves and what not. Lightroom is much faster and better than photoshop for color correction and photo management. I use iPhoto to import and organize my photos- and lightroom to tweak the color. The cool thing with lightroom is the custom presets you can build; once I color correct a given photo, I can save the settings and apply them to any other photo I want. Furthermore, If I want to apply the same settings to a different photo at a later date, the preset is in my row of buttons.
My "secret" recipe for color correction isn't rocket science so I'll try to create some screen shots to post here. I know everyone doesn't have a camera that can shoot RAW- so some of the color stuff can't be easily done. For the most part, I just tweak GAMMA, CONTRAST, BRIGHTNESS, EXPOSURE (RAW Only), WB Point (RAW Only), R/G/B channels and Curves.
I'll also post some before and after pics...eventually.
As far as cameras go, I use a Nikon D70s with the 18-70mm "kit lens." I DON'T have a macro lens anymore, so I have to make do with what I have. [i do have a Kodak V570 w/ decent macro] The camera/lense isn't the most important factor in a good photo.
I've learned that LIGHT plays a bigger role than anything. The beach shots of my EXP II were taken during "the magic hour" basically Dawn and dusk. The atmosphere filters sunlight in an almost magical way ala "Vanilla Sky" It's the best time to take any picture- heck you could make a canal street rep look good ;-)
I'll try to come up with some visual aids to illustrate my points a little better. In the mean time, please enjoy my photos and ask questions.
-Mike