Is Lightroom really all that helpful in terms of photo storage and organization?
I know absolutely nothing about it.
What do you currently do or want to do w/ your photos? And as others asked, do you often/regularly shoot RAW?
Personally, I've found the less expensive Adobe Elements combo (of Photoshop and Premiere Elements for both photo and video) to be a very good value even if you do shoot RAW... as long as you don't find a need to batch process them.
Photoshop Elements does miss out on some capabilities I'm used to, eg. full curves functionality, from a (*very*) old version of full Photoshop, but it otherwise does most everything I need in terms of editing, including RAW conversion (for my Nikon D800 *and* lower end Nikon bodies)... while serving just fine for my basic cataloging needs so far -- and yes, I do keep a ton of old photo files and don't regularly cull out or prune them... although I do try to toss the obvious bad ones before putting them into my archive instead of what Cameron does. But I don't normally batch process a ton of RAW files though which is (I imagine) probably where Lightroom does much better along w/ certain other approaches to editing/processing that probably suit pro photographers more.
IF I were shooting gigs (in RAW) and need to produce sizable batches of photos w/ some regularity, I'd definitely go for Lightroom (or something else perhaps), but that's not what I do. Most times, I'm much more deliberate in choosing and processing a small set of photos to be presented, etc., and I find the JPEGs I get from shooting RAW+JPEG to serve just fine as prescreening "proofs" for that purpose -- and they are often also good enough to give away for more casual uses to family and friends... maybe w/ a minor tweak or two perhaps.
For a good comparative summary review, maybe check out this one I just googled for yah:
It might be a tad outdated by now, especially regarding PSE functionality, since it's from mid-2013 -- Adobe comes out w/ a new version around Q3 of each year.
Hope that helps some...
Just another amateur learning to paint w/ "the light of the world".
"Whatever is true, whatever is honorable, whatever is right, whatever is pure, whatever is lovely, whatever is of good repute, if there is any excellence and if anything worthy of praise, dwell on these things..." (Apostle Paul)