This is what Brave's "Forgetful Browsing" does. There's even a slight delay, in case you accidentally closed the tab.

You can configure the "Cookie Autodelete" extension to behave in a similar way.