@Suvarna G. Keep in mind that appraisals are trailing indicators, going up to six months back. So a lot is going to depend upon the transaction activity either in your complex or nearby.
Sorry you've had a bad experience with your appraiser.Unfortunately, we do have a few appraisers on Maui who seem to think that their opinions are akin to gospel. Rather than look at the reality as it is, they seem to think they have the right make their own market, rather than doing their job of simply appraising the market value of the property. Operative word being market value!
I would say not a warning sign about our market. I've had clients who have had no problems with their property appraising out. So I would attribute your situation to one where you ended up getting an incompetent person, just like in any industry. Maybe consider requesting a second appraisal? Will cost but if its important, then do it.
The market is tight and likely to remain that way. Too many owners have cheap money loans so don't expect to see a flood of inventory.