On Saturday, after I said good bye to the greatest cat ever, I was sorta depressed and went down to my local electronics superstore to... check out keyboards. I've tried pretty much all of them. Some observations (no Lenovo keyboards there, BTW):
A High-end Sony Vaio notebook with a non-MacBook-like keyboard had very good tactile feel. Some Toshibas had a pretty good feel. The MacBook Pro was quite good as well. The MacBook I could not really make sense of. I could type on it (I can type on anything), but don't know if I could live with it long-term. The new Aluminium Apple KB is not quite the same as the MacBook. The keys are firmer, with even less feedback. I am now convinced that the next Apple KB will be a touch-screen. No doubt about it anymore. When it happens, I expect fanbois to hail it as the best thing since sliced bread, even as they take 2 hours to type up a single sentence of gushing praise.
As far as standalone keyboards go... I found that an entry-level MS keyboard had a better, more tactile feel than a Logitech BT wonder 10 times its price. The MS Comfort Curve 2000 felt surprisingly good, given how cheap it is. As with almost all MS keyboards, the spacebar is the big letdown. Much louder and clunkier than the other keys. I have no problems with noise, as long as it's justified by quality tactile feel and is consistent among the keys.
The new Logitech DiNovo Edge was kinda boring looking in the flesh, and a fingerprint magnet to boot. The scissor-switch keys were definitely good, except for the spacebar. Still, I don't think it's worth the money. The OMG l33t w00t (whatever else the youngins say these days) Logitech G15 was nothing special.
The now old Apple keyboard is lame. It's long-travel, yet the activation point is almost at the bottom, and the down travel is not smooth, and the keys rebound slowly.
There were no mechanical keyboards.