This is hard one because most of the one shots are just awful as they rarely include any guidance to how to run them in short of time. At least every one shot should include a guidance of how and which parts to leave out when time is running out.

So the best ones are usually systems designed for one shots without separate scenarios but assuming you are asking about those the most palatable one has been DnD 5e adventure Sarah of the Yellowcrest Manor from Candlekeep mysteries. The middle part can be pretty much skipped if the time is limited, there is at least some guidance on how to run it and the end dungeon is short and sweet.

The Crew -games would be pretty similar to The Game.

Multi-session cooperatives:

• Arkham Horror the Card Game

Single-session cooperatives:

• Pandemic
• Paleo
• So Clover!
• Mysterium

You can also use search like this to figure out something that really fits to your table (Might take long to load!): https://bggbester.netlify.app/?b64=AhMCAgUABgAPAxAlA-gCAwsDCxUFGwMMAw0ldTAHFQUcABMDEgMRJQfqFAMVAwQCFgAZABcAGAABAhgKB-cYCgsE

The Alexandrian has vast amounts of posts about it: https://thealexandrian.net/in-the-shadow-of-the-spire

I think the main way I acquire new ttrpg reading at the moment might just be Goodreads’ suggestions.

Secondary sources for me are things like different ttrpg communities in lemmy and mastodon.