Improve sorting of integrations

[alexfrancoeur]

Description

In 7.16, we defaulted to the integrations view for all ingestion options and added non-agent integrations for improved discoverability (#93084). While this is a significantly improved experience, we are looking for ways to improve discoverability of integrations in this view. We are planning to tackle search improvements (#118897) and believe sorting will also help users navigate the integrations available to Elastic. While there is plenty of prior art out there for sorting and navigating large amounts of entities, we'll plan to start small initially.

User stories

• As an Elastic user, I want to sort by most popular integrations across the Elastic user base
• As an Elastic user, I want to sort by most recently added integrations
• As an Elastic user, I want to sort by most recently updated integrations (I think this could be useful, but let's discuss)
• As an Elastic user, I want to sort alphabetically

Capabilities

• Ability to sort integrations by popularity, release date, update date and alphabetically
• Sorting should be applied to any search or facets already filtering the integrations
• Release date, modified date and popularity as metadata for all integrations
• Overall popularity will need to be captured for integrations and we'll need a way to update them with each release, dynamically or a combination of the two
• Potentially telemetry to help capture popularity
• Depending on complexity of delivering some of these capabilities, we should prioritize the Cloud experience first

Definition of done

As part of this enhancement, our end goal is to increase the click rate of integrations within this page. Users should be able to find what they're looking for. When we are confident that our sorting capabilities and results match expectations for our users we can call this feature done.

[alexfrancoeur]

cc: @mostlyjason @LL6688