We have many physicians move here, love it (even with COL/salary), and make Hawaii their permanent home. I also know many others that just couldnt stay here >1-2 years.
Sure it's expensive, but if you're good with budgeting then you'll be just fine. I mean, cant put a price on this weather
Re "Locals only" attitude, that's not true at all. You're treated the way you treat others. So if you move here and then complain about the people, the culture, have an uptight attitude, and constantly grumble about how it's "not like the mainland" ... no one will want to be around you.
Be cool, stay kind, go with the flow, and you'll be treated like family and invited to too many bbq's.