The short-term rental market in Arizona, particularly in popular tourist destinations like Phoenix and Scottsdale, has been growing rapidly in recent years.

First it is harder cashflow in Hawaii than some of the other states, then often times the condos are on a land lease which makes it less desirable from a purely investment perspective, finally HI (from my limited understanding) has enacted increasingly strict STR regulations in many of the major tourist hubs.

The only thing that irritated me a little was tourists coming to Schlitterbahn.

For example, today Las Vegas hosts millions of Chinese tourists each year.

I'm using my own house right now as a short term/vacation rental, and we're not in a tourist destination by any stretch of the imagination. 

In the beautiful tourist haven of Monterey, STRs are illegal if they're less than 30 days.

Personally, I prefer areas that aren't as reliant on businesses and tourists for the economy. 

I don't know of a STR banned city database.You can search through this forum.If you pick a tourist town then you should be OK as they get a lot of revenue from tourism and will likely not do anything to upset that.

All you have to do is choose the right area, one that tourists will flock to.....I mean...why wouldn't you...?

Every town has it's own type of tourist.