A comprehensive compendium of specific use cases from the HEP and RA communities, an analysis of their current requirements and future evolution in terms of code characteristics, features, and computational demands. A comparison of their current and future technical and non-technical (policy) requirements with the existing RI landscape will result in a gap analysis. Taking into account the evolution of scientific requirements and new opportunities related to new hardware and software technologies, solutions will be suggested to close the gaps and to address remaining challenges. The relevance of the use cases will also be confirmed with other data-intensive science disciplines for wider impact.