As someone replaying TP, lol no. I'd say BotW was closer to it, and Majora's edges out both, no pun intended.
TotK... doesn't really have anything too heavy to it. It's pretty much a basic "Where Zelda?" with the regional phenomena around the temples where some Sages are awakened and we all know Ganondorf messed everything up. That's closer to OoT's Adult Link's section but the Sages don't go poof.
Sure, it has some scenes that are a bit more impactful, but it's nowhere like TP where the plot makes sure to get personal with Link and Midna 24/7.