Barcelona long term hotel

You're best waiting 'til after the U.S. elections in November before making plans to travel to Catalunya.

I readily admit my IQ is less than 190, so I need some help in understanding how this helps OP select a hotel for a stay hoping to occur in October

@hkirkwil, excuse me if I am not too helpful in answering your question. As a resident I have no use for hotels and, frankly, I am not in the loop on what's best or what's new in the hotel scene in Barcelona.

I, however, would like to point out that for the time being, it's adventurous thinking on a holiday trip to Europe for the rest of this year (at least). Not only there are indicators that by October there might be a 'second wave' which might require further partial confinements (lockdowns) --especially in large cities here in Europe-- but also, the current trend in the US regarding the management of the pandemic is quite alarming so it's unlikely the European Commission will recommend its member states to open up borders to visitors residing in the US for the foreseeable future.

Even if borders open up, should an outbreak suddenly appear, you risk being locked down and not being able to leave for a while. With the past experience on how the outbreaks spread, time is of the essence, so fast lockdowns are a must. Factor that in!

Btw, a two-week stay is not considered here "long term", for that you'd need to stay over 30 days. This is to say that price-wise there won't be "that much" difference in the "per day cost" of the hotel whether you stay four days or fourteen. Have you considered renting an apartment instead? That might be slightly cheaper in the end for such a length. If interested, browse bookings.com, airbnb, or homeaway among others.

I agree, unfortunately October is probably unlikely. But if you want to dream, we stayed at this place: https://www.hotelsilver.com/ Aparthotel Silver. It is not exactly central, but close to a metro line and the neighborhood has quite a few restaurants, a market, and shopping. The price is decent, and most rooms have a kitchenette, at least a refrigerator, microwave, maybe a bit more, so more comfortable than a typical hotel room.

A nice apart hotel near La Sagrada Familia:
Hispanos7Suizos. We spent a week there, helpful staff. Just the two of us but had two BR, two full baths, full kitchen and W/D. Balcony too.