If you get one of Shuttle's XPCs with a 240/250w PSU, then you should be fine (power-wise).
Captain slug:
A) True, except some (most?) people don't upgrade their mobos more often than their platform (CPU/Mem, etc.).
B) ?! Explain. You can have 2 hard drives in just about any SFF, and in this case that's all the poster has.
D) While this is true to some extent, you can fit everything the vast majority of the enthusiast community needs in an SFF. DVD Burner, high-end video, quality audio. The higher-end SFFs have integrated SATA RAID, network, and sound (if you feel like swapping a TV tuner for a PCI sound card).
E). As long as it has a single-slot cooling solution, it will fit (except for a few FX5900s with right-angle power connectors). Power *might* be an issue down the road, but that is still up in the air.
I left C) for last, because this is the clincher:
What voltage are you running your 2.8C at? If it's stock, or very close to stock, then you'll be fine in an SFF. BUT, you'll be able to overclock farther, and with less noise/mhz in a tradition ATX system.
If all you want is performance and quiet, then an SFF is probably not for you. Instead just get a good HSF like CaptainSlug said and relax. If portability is at all important to you, then look seriously at SFFs. I'm biased because I take mine somewhere at least once a week, but being able to fit your entire high-end system, keyboard, mouse, and cables in a small backpack is great.