I think the Mini gets an undeserved bad rap.
I got one of the "low end" new ones about 4 weeks ago and I love it.
My main computer is a from-parts PC w/ 45nm core 2 duo OC'ed to 3.0, 8 gigs ram, RAID 0'ed raptors, 9800GX2, yada yada yada. It's relatively fast, but it also sounds like it's going to take off when it's running and draws around 500 watts under load. For everything except gaming it's overkill.
With the new '09 Mini, I cracked it open as soon as I got it and put in 4 gigs of ram I had in my craps drawer along with a WD Cav Black 320 also from the same drawer. Kablamo. Thing browses like a champ, runs Lightroom perfectly fine (preview rendering a little slower, but not painfully slow) and drives my two 24" monitors perfectly. MKV playback over my network via Plex is also flawless.
Bootcamped Vista is a-ok and runs Civ4 BTS as well as my PC does, even in endgame.
All this and I can't even hear the thing running and it uses a fraction of the electricity that my PC does (which now only gets turned on when I want to kill stuff). Important feature going into central A/C season.
Just for laughs I took the Vertex SSD out of my laptop and put it in the mini. With that the Lightroom previews were rendering just as fast as on my PC, if not faster. Maybe in the next couple of months I'll get another to permanently install in the mini.
That said, I wouldn't have touched the last mini with a 10' pole because of the poopy Intel integrated graphics controller.
My point, if I have one, is that the Mini is good for more than just browsing. I think it makes a perfectly viable mainstream computer that's light on power consumption and ambient noise.
John
I couldn't agree with you more as I find myself very close to your same situation. I have a beast of a PC performance wise that I built (though mine is actually pretty quite for what it has under the hood) and I have a 2009 Mini that I cracked open and installed 4 gigs of ram and a 7200rpm / 320g hard drive in right after purchase. While the mini wouldn't touch my pc for high end gaming (I seriously doubt a mac pro would either) its perfect for just about everything else. I could not be more happy with this mini and find myself using it for just about everything and it runs like a champ.