We stayed here for 2 nights on our first visit to spain, the location is not centrally located to the tourist sites but it is a great location for taking the subway, train and hop on/hop off bus around the city. It was great to be able to take the metro from the airport to Sants then walk out and see our hotel across the street. There are cafes around the block as well as inside of the Barcelona-Sants station, there are lots of travelers walking around so it is pretty safe at night .
The staff was pleasant, the rooms were pretty standard unless you upgrade. We upgraded to a room with a view only because it was the" only" room they had ready , it cost $12 euros/day for the upgrade and it was worth it for the extra comfort and view.
I would highly recommend this hotel although there are several other hotels around the Sants station that are a bit more cost effective for long term trips.More