I use huge, for much the same reasons people have already mentioned; the bigger clunkier units just feel "more right". And avoiding the population depletion is certainly a major encouragement for building all those sewers and doctors and whatnots...

And, yes, my comp can take it. At highest unit detail and low anti-aliasing to boot, in 32-bit 1280x1024.