Wow.. For at least the first of those examples you are completely wrong. You can edit all the contact information on the android phone itself. You just go to your contacts on the phone. Long press on the one you want to edit, select edit contact and type in the name in the first box.
Since everything is synced to google you can also do this change on gmail, or even google.com/contacts. I don't know where you got the idea that you have to edit CSV values.
Also looking at the music app on my g1, (which i don't really use, yay zune hd) I'm not sure where you are coming from. To get to an artist I open the music app, click the upper left button labeled artists, and then start typing to search. To play an entire artist just long press on it and select play.
Getting pictures off the phone is as you say, although there are third party apps you can get to do bluetooth transfer, or even just upload your photos to picasa, or email them to yourself. Now that I think of it just use the import functionality on something like picasa. For the last of these getting pictures off my G1 is no harder than getting them off my point and shoot.
What android phone were you testing these on?