Managing Overlapping Leads in Shared CRM for Commercial Real Estate Agents

We are a commercial real estate sales brokerage managing a shared database for a team of over 25 agents. While sharing access to Properties, Contacts, etc., has been generally effective, we face a significant challenge with Leads. 

In our context, a Lead typically originates from an inbound contact clicking on a "For Sale" listing. The challenge arises because leads often overlap across different agents' listings. For instance, if John Smith clicks on three different listings from three different agents, he becomes a Lead for each, resulting in multiple interactions with different outcomes tracked by different agents. 

Here's how we've been tackling this:

• Current Solution: We've introduced a custom object called "Listing Lead" which merges data from both the Property and Contact pages to create a unique record for each agent's interaction with a lead. This approach has been somewhat effective but falls short when the same contact is a lead for multiple properties under the same agent. We've utilized related lists to link other properties and activities, but these cannot be easily filtered or displayed in list views, diminishing potential efficiencies.
• Specialized Solution for Top Team: For our top-performing team, we've implemented an advanced system involving a complex Flow and custom fields on the Contact object. This allows for detailed tracking of leads at the contact level, which works well but isn't scalable across all agents due to:

• • Scalability Concerns: The setup requires unique custom fields and flows for each agent, which becomes an administrative burden, especially with the high turnover in our industry.

I'm looking for the community's input on how to better manage this scenario:

• Ideas on improving the "Listing Lead" object for more nuanced tracking?
• Suggestions for a more scalable system that could handle agent turnover and varied lead interactions?
• Any Salesforce features or third-party apps we might not have considered?

I'm open to all ideas and am happy to provide more details if needed. Let's brainstorm solutions to streamline our lead management process!