I had the same question three months ago and read this thread for ideas. Based on what I read, I purchased the Bio Stack from Smith and Hawkens and I'm very happy with it. It comes with good instructions, it's easy to set up and use and it's about as attractive as a compost bin can be (in the photo, it's the black box behind the bed). You aerate the contents by re-stacking the bins just to the side and shoveling (or pitch-forking) the contents into a new stack. Ideal situation is a sunny spot 4' deep x 7' wide. You could leave the 3' x 3' Stack in place and turn the contents inside, but that would require some extra strength if your compost pile grows higher than one of the three levels that come with it.
It arrived in 3 days and soon after Smith and Hawkens emailed a 20% discount for my next purchase. I splurged on a stainless steel kitchen bucket with a carbon filter in the lid, and even after I forgot my little stash of egg shells, banana peels and veggie trimmings for more than a week, there was no detectable smell (until I took the lid off ... argh). I'm happy with this purchase as well. It saves me from running outside every time I have kitchen scraps to add to the pile.
Contents so far: pine needles, a $1.98 bag of top soil, a bag of grass clippings, coffee grounds (including two XL free bags from Starbucks), veggie trimmings, fruit rinds & peels, pansies and Siberian Husky fur. When I open the lid, it smells like coffee and grass - and it's still in the rotting stage.