At this point, I've identified three promising candidates:
Call from the Deep
Odyssey of the Dragonlords
Dungeons of Drakkenheim
They're all 1-13 campaigns. They all have at least some good reviews. They all offer custom material such as races or backgrounds (which I'm not going to use since this is a 2024 PHB playtest). They're also very different from each other.
Deep is probably the most straightforward or vanilla, in that you're playing "true" heroes, and the campaign is more or less a string of events that take you from one place to the next. This sort of campaign is easy for players, but motivation can be hurt if players feel their actions don't matter, they're just along for the ride.
Dragonlords is probably similar in structure, but everything is covered in a thick layer of lore and background. Luckily it's set in a fantasy version of ancient Greece and not the real thing; players aren't asked to remember details from actual legends. Not sure my players will feel at home; it's critical that as a player you feel confident within the setting, that you know what and how you can act without being surprised. (If you don't watch police procedurals or read sci-fi, you can feel lost if you play a gumshoe adventure or play in outer space. Not everybody is well-versed in the genre tropes of detective stories, science fiction, or in this case, greek myth and legends)
Drakkenheim is very open-ended, in that it doesn't care how you achieve your goals, who you ally with and who you destroy along the way. It also feels like the risky option: more than one module turns off the players by being too dark, too grim and not sufficiently motivating the players to keep risking their characters' lives.
Haven't made any final decisions just yet, but maybe I'm leaning toward Drakkenheim. After all, if the DM isn't invested in the world or the story, nothing can save that campaign, so I need to choose something that gives me energy.