http://www.engadget.com/2008/04/21/rancilios-silvia-espresso...
The episode also appears to be on Youtube for the impatient.
Affiliate link: http://amzn.to/bmCMbK Regular link: http://amzn.to/bTsI8d
You won't get anything better than a semidecent froth on amateur machines like this no matter how good your technique is.
They either lack the necessary pressure or run out of steam midway.
This is about the best you could probably get: http://thealps.files.wordpress.com/2008/08/img_6168.jpg
This is what you want: http://upload.wikimedia.org/wikipedia/commons/1/16/Classic_C...
The Saeco machine I bought has a built-in grinder, so its relatively clean. Makes very consistent espresso, good to very good with the right beans. The machine is quick to heat up, has two heating elements, and foams milk well. The build quality is better than the Gaggia machine I replaced.
I can't recommend a Moka pot, unless you're very precise, patient, and have an equally precise stove. Aeropressed, french pressed, and cold pressed are great ways to get good coffee, but they're not espresso.
At the volume and price you want, the Silvia is likely the best choice. You don't get great precision/consistency, but with some practice you will get great shots, and it will last a long time. It should be paired with a grinder like the Rocky at the very least.
http://www.amazon.com/dp/B001NAATK2/ (DeLonghi EN670.B Nespresso Lattissima)
(Edit: If you're not looking for automatic, you can probably scratch this one from your list.)
- Mainly for espresso, or also for capuccino and others (ie. good frother)?
Not fully automatic.
For home/office use - several shots a day.
Mostly for espresso, someimtes capuccino (80/20)
Not interested in bells/whistles/computers - just good espresso.
Solid quality/durability/maintainability is a plus.