For a stay in the USA that doesn't break the bank, we've gathered together some of the loveliest affordable hotels.