Great city, but I picked the middle option as it's tricky with only 3 and there are better places out there, as well as a lot worse.
For context, I lived in Madrid for a few years so had all the emotions where I could have selected anything on the scale. My vote would actually be for between 'OK' and 'Awesome'.
As ever, a place is what you make of it, down to the individual and what the circumstances are…