Right now, when the current active tab is closed, the tab on the right is activated. This is a common pattern in web browsers and multi-tab native apps.
Given that obsidian is an editor, it would preferable to default to (or add the option to) reactivating the previously active tab. This will speedup users who want to resume working on their last active tab/note.