Coda and other alternatives to Adobe

Someone in the Mac community turned me onto Coda, by Panic. My hard code skills are weak but I've intended for a while now to transition into more hard coding, so maybe I can take it nonetheless. And, it will force me to learn to hard code, whereas Dreamweaver would not.

Any thoughts on it?

Also, any recommendations that are NOT Adobe but arguably as good for any purposes I might possible have for:

• photo editing (aka photoshop type stuff)
• more object oriented editing (aka illustrator type stuff)
• audio editing (better than garageband but not exorbitantly expensive)
• video editing (probably doesn't need to be nearly as fancy as Final Cut Pro, but still able to turn out reasonable content)

I bow to your wisdom, Int0rw3bs.