Is buying property in smaller cities finally worth?

With prices skyrocketing in major cities, many investors are now looking at smaller cities. But is the demand really there, or is it just hype?