My biggest advice would be to plan your hotel before getting too deep into NYE activities, as a convenient location can save a lot of hassle on busy nights. The same approach works for other destinations too, and checking guides about
best hotels to stay in Barcelona can help when comparing different areas.