A very successful real estate investor once told me that, if he had to do it over again, he would have purchased more properties with a lower cap rate.
To new investors, this will seem counterintuitive because the cap rate indicates the rate of return on the property, but the reality is that it also suggests the risk. For example, many small-town investment properties will trade at a high cap rate, often in the mid-teens. This is a high rate of return. Bit, it assumes that everyone pays their rent, that tenants continue to rent, that things go well for the town (many small towns are dependent on a single sector or industry such as oil, forestry, pulp, mining, etc. so if the town loses its primary industry, it may take decades to recover). So, assuming everything goes perfectly, this is an excellent investment. But, the moment things go sideways, not only does the asset lose value, its liquidity goes out the window as well.
A lower cap rate indicates a smaller return, but if it's a realistic price, then typically, these are well managed, highly desirable locations with strong fundamentals and lower risk. It also means that there will be greater liquidity for the product when the time comes to sell. It's also likely that the property will have a higher average lease term and will be less management intensive due to crime or vacancy issues.
If you've ever seen the start of Schitt's Creek, the reason that the government seized all the family's assets but not the 4,500-acre town they owned is because of the hilarious illiquidity of the asset, and the governments inability to sell the property either! It was a boat anchor, and had no value without substantial work.
Cap rate matters, but what matters more is the owner's ability to service the debt and come out ahead on the investment. Overall, the investment has to "make sense."