Assuming you don't want to spend any money...
I'm still experimenting with this:
http://www.flickr.com/ For an on-line solution it seems pretty cool, with tag based organisation, sharing etc. Check it out. It's free but still in beta.
If you're using Win XP, the standard photo functions included are ok. They're enough for my off-line needs anyway (organising and easy viewing). Just store all your pictures in your 'My Pictures' folder. There's a slide show function included. Using XP has the advantage that you don't need to install the Sony software on your PC, since Windows will recognise the camera and start a dialogue to help download your pics to the PC.
I rarely add titles to my pics so don't know of any mass editing tool. I just use Fireworks when the need arises.
[ January 06, 2005: Message edited by: Richard Hawkes ]