As far as machines go, to answer your initial question, the Bowflex U2 is probably one of the better ones. As for which would be best for you...you need to ask yourself some simple questions: is space the only concern?
Clearly, price is not an issue, so is it the time factor in going to a gym? I don't mean just the drive there but the waiting for racks, dealing with morons, etc. Do you value your privacy that much? What are your goals, or, what is the purpose, of your training. Simple fitness, competitive bodybuilder, elite atlete? All these will factor in to your decision.
There have been some good suggestions listed. A couple of words of advice if you go the Bowflex route:
1) get the 410 upgrade;
2) get all the attachments
3) if you need more resistance, add some power bands
4) if you squat more than the 410, you can always stand on a couple of books (the reistance is greater in the "up" position)
I have used a Bowflex and have had results. The listed resistance "weight" is somewhat deceiving: there is a noticeable difference when you use free weights.
Some thougts, and I know there are many more to come.