2 Megapixels or 24 Megapixels?
Only ten years ago!
But, you know, my PC screen is only 2 mp... 1920 x 1080... and, at 300 dpi, that would give me a nice 6 x 4 print... easily also a 5 x 7... so I think you could use just about ANY P & S for web or print (ads and brochures) work! Large wedding pix, giant posters, no... but do you really want to get ulcers shooting weddings?
PS nice picture of Liverpool on your blog -- was the ship in the Falklands war? Is your city going to make it into a museum?