I have advocated the mSATA route for a while for a variety of "unusual" applications. I have a trio of last generation Powerbooks(12" early '05, 15" and 17" DLSDs) running 128gb mSATA drives and they are impressive. At least on the DLSDs, the drives will saturate the bus save for about a 5mb/s overhead loss in the adapter, and the machines honestly don't feel that slow unless I start bogging them down on the internet.
I came into a stash of 60gb 7200rpm drives a while back, and I've used those in several other laptops. Since laptop ATA drives don't exactly go on trees these days I tend to save them for computers I actually use and then use the pulls from those computers in other instances when I need a drive. At the moment, I have these drives deployed in my 1ghz TiBook that I use frequently, a Pismo, and a G4-upgraded Lombard that I'm trying desperately to get Leopard running on(long story). The 867ghz Ti my dad uses to play CivII also has a 100gb 7200rpm that was pulled from my 15" DLSD.
If you browse Ebay, you'll see a lot of Kingspec branded 2.5" ATA SSDs. I've not owned one in that form factor. I did, however, buy one a few months back to install in my first-gen MacBook Air. These computers use a 1.8" ZIF ATA drive, something probably more commonly known as an iPod drive. I had a nice 256gb Samsung mSATA drive for the computer, but none of the adapters I bought would properly engage the ZIF cable. I finally bit the bullet and bought a 128gb Kingspec, which was not inexpensive considering the size. It fit perfectly, but the performance is pretty underwhelming. Sequential read and write top out in the neighborhood of 50mb/s, which I think is about half what the bus is capable of.