Sorry to hear about your experience. Mine was wildly different, and I came away with entirely opposite impressions of their service industry.
> no public transport to speak of
How did you manage to miss all the huge flashy light rail stations? It was really convenient to use for travel throughout the city. Especially as a tourist -- just about all tourist destinations are close to a station.