I think visiting the place and living there are likely to be very different experiences. Gibraltar is very small. The Europort expansion has increased the size of the territory significantly but some areas of Gibraltar were rather run down when I last visited (which was 2004, so could have improved). It had the feeling of having a poorer underclass about it and in such a small place the separation away from that cannot possibly be significant. At the time there were only a couple of supermarkets and the Spanish can (and did recently) cause havoc at the border which is inconvenient if one wishes to get out and do something beyond the confounds of the territory. It is probably a fine place to live if one chooses not to spend a vast amount of time there because there really isn't very much to do due to the tiny footprint. I met an estate agent at the time of my last visit and looked into living there but I think I would have become very bored within a short period of time. There are plans to improve the airport, diverting traffic that currently crosses the runway via a new route and for a road tunnel under the runway to be built. Unfortunately the project is progressing slowly. There was a recent power outage which knocked out all of the offshore online betting entities for a while.
Someone I know spent time growing up there, since his father was based in the navy over there, but when we went back I think the realisation of how Gibraltar is today made him rethink the importance of nostalgia. I imagine the place is great if one is a heavy drinker and smoker. Overall I think I probably made the correct decision not to move there a decade ago.