Not much to add to the wide variety of insightful comments here, but if you'd like an American comparison, Madrid would be more NYC (busy, finance, big co's HQs, cultural offer) and Barcelona would be California (sea, weather, hotter startup scene, more laid back).

Both are awesome and whatever you choose you can't go wrong.