I think it is always an interesting dichotomy with regards to posters who debate any submarket being hot or not hot.
Those who are actually out there looking for homes tend to be frustrated by lack of inventory or homes that are well overpriced (usually both). Those who like to sit in front of computers digging up redfin data love to bring up statistics and debate about time on market or how the sold price is a certain percentage below the list price. (Never mind that the list price was incorrect to begin with)
Markets move slowly but the problem (when you are a buyer) is that the inventory selection of what you really want moves even slower. Fairly long periods of time can pass before you find what you want.
You can say Mira Mesa is not on fire but I would disagree. I think most of the I15 corridor is a pretty tough buy right now. Homes sitting on the market are only there because they are poorly priced. Just because they don’t sell doesn’t mean the market is not very difficult for buyers right now.