Here's my scorecard so far:
Subsonic - I had some problems setting it up, but once I worked out the kinks, this seems to be the best option so far. It has a very simple option to delete the cached music. The interface on the Droid is far from lovely looking, but it is the one I am using the most right now. While I was typing this, an update for Subsonic has come out!
Orb - I really thought this was going to the "the one" I was looking for to stream music. The interface is awesome, and the setup was EXTREMELY easy. HOWEVER, this is the only Android app I've seen that DOES NOT multi-task at all. If you press your home key, or try to do anything but listen to Orb - no music. As much as I loved everything else about it, this is a deal breaker for me. If I planned on just listening to music and not doing anything else with my phone, I would have bought an ipod. Since Orb was originally used on the iphone, I guess they just ported over the code for Android and didn't take multi-tasking into account.
MeCanto - MeCanto seemed to stutter and pause while playing more than Subsonic. To be fair, I haven't used this one as much. The interface is pretty blah - no artwork at all. It was pretty simple to set up.
GMote - Like MeCanto, I haven't done a whole lot of testing with GMote. I had some early problems with port forwarding, but I seem to have taken care of that. The interface is UGLY - album art looks compressed and distorted.
Jinzora Mobile - I have downloaded the Android client, but that's as far as I've gone.
These are the other apps that I understand will stream music from a home computer:
Remote RDP
StreamFurious (?)
DroidLive (?)
RemoteFile
DroidTunes
Moozone
Any input on the above would be great! I will probably play around with GMote and Mecanto some more this week before I decide whether or not to donate for Subsonic.