The cynic in me things the Dems take the legislative branch next year, curtail executive power but are unable to undo anything and then win a massively nerfed executive position in 2028.
This is an extremely optimistic view. I don't think the Dems can take the legislative branch (certainly not the Senate).
I'm with you. I also think it would not take long before we all found out that the Supreme Court only embraces limitless executive power when the office is held by their party. We've already seen evidence of that, Trump has succeeded using arguments that Biden failed with just a couple years ago. Right about the time 2028 rolls around, the Supreme Court will suddenly decide that they've gone too far and need to reel in an out-of-control executive branch.