Re Barcelona, it's so overhyped. Sagrada is quite the sight but beyond that there's no real beauty
I thought it was one of the most beautiful places I'd ever seen, and I've been back a few times. I love spending hours just getting pleasantly semi lost in the massive Gothic quarter just off La Rambla, and El Born just next to it. Coming upon yet another beautiful little square, or the Parc de Ciutadella.
We got a bus right up to the top of Tibidabo and enjoyed the views over the city, the beautiful little church and the random but very cool retro amusement park.
The second time we went we stayed in Gracia and it was so nice to ramble back from the centre and then find loads more to see and do there, loads of cool little shops and bars and busy squares. Third time we stayed in El Poblenou and loved the huge long beach walkway that took us all the way along past the bars, Barcelonetta and the harbour.
Obviously Parc Guell is absolulely amazing, and Casa Batllo and La Pedrera are incredible buildings.
I saw beauty everywhere.
La Rambla itself is just too crowded to be particularly enjoyable at most times of the year and there's the constant tension of watching for bag snatchers, that much is true. But get away from that/Sagrada Familia and it really doesn't feel that frenetic.
But, as this is a thread about places we didn't like, I'm afraid I'm going to have to be another vote for Dublin. There was somewhere that I couldn't find any beauty. It was dull, grimy, depressing, unfriendly and expensive. I've given it several chances as well as I've been for work a few times but no, never managed to find the charm.
I'm weirdly ambivilant about Portugal. I do like it, I just don't totally love it the way some people do. It feels sort of mournful and seems to rain a lot.