Deals like Michael Herbert’s £22.7m purchase of a Co Down shopping centre were the bright spot in a torrid 2024 for investment property, a report has said.