I'm using an Adata SSD S599 64 GB in my macbook pro right now and it works great.
Before this, I used the Kingston V Series 40GB that was basically a rebadged Intel SSD with TRIM support disabled in firmware. I replaced it with the Adata one because I was having issues with system hangs, mp3s skipping, due to fragmentation, and lack of TRIM or garbage collection in Mac OS X.
The Adata SSD which uses a Sandforce controller and has built in Garbage Collection has been great, but there are issues with hibernation that have been mentioned, but can be worked around by disabling hibernation. My Adata SSD is in a drive caddy where the optical drive would be, and I have another Hard Drive in my Hard Drive Bay for Media files. There is an article on Anandtech about Sandforce controllers and firmware versions and respective issues.
Currently, all I am aware about are the new Intel SSDs and the SSDs based on the newer Sandforce controller. With the newer Intel SSDs, my main concern would be fragmentation and when TRIM support would be available (from what I know it will be in Lion).
If I'd choose a newer Sandforce based one, I'd do more research to make sure any issues with firmware versions are present. But likely if I had to buy an SSD today, I'd get one of the newer Sandforce based ones, so I wouldn't have to worry about lack of TRIM/garbage collection and the potential issues.