I’m sure some of the well-qualified real estate professionals on this forum can better answer your question, but I just wanted to respond based on what I’m currently seeing in those markets.

Several family members and friends live in Mission Hills, Point Loma and Sunset Cliffs, and, especially recently, they have seen properties around them selling for above asking prices. There seems to be a renewed interest in the area of late.

My Mom has a neighbor in Sunset Cliffs who is a Patent Attorney, and he spent a million for the property, tore it down, and is now spending another 2MM to rebuild. Same story across the street from her with an insurance executive.
(My parents paid $70K for their house in ’78, so go figure)

As in all areas of San Diego, there will be deals, but my suggestion would be to start working with a reputable realtor to help you find the gem you are looking for at the price you wish to pay.