November is still a good time, but you need to be careful about how you book. Those 150-200 euros you're seeing are weekend prices or days with shows/events in the city - if you pick a fixed Tuesday or Wednesday instead (not around holidays), prices drop like crazy. The trick nobody mentions is checking check-in times: a lot of hotels have rooms available in the afternoon at normal rates, but if you want to get in early in the morning they charge you more. Try booking with check-in after 3 PM and see how the rates change.
As for the rest, Barcelona stays expensive because it's Barcelona - it's not going back to prices from 10 years ago, that's just reality. But if your question is "is it still worth it or not", the answer is yes, especially if you don't want to drive around all of Spain looking for the perfect city. Madrid, Valencia or Zaragoza are cheaper, sure, but they don't have the same appeal. If your budget isn't super tight, just do a Barcelona weekend and call it a day. But if every euro counts, go to Valencia - it's beautiful and costs less.