[Tabs] Consider alternative overflow display type

Check existing issues

[X] I have checked for existing issues to avoid duplicates

Description

We received feedback that a built-in overflow menu of Tab Titles could be a preferred experience vs. the "arrow overflow".

Acceptance Criteria

Consider adding an "overflow list" to Tabs as an option alongside the current “arrow overflow”

Currently, I can build my own UI to achieve this "overflow" menu - but it must be separate from the Tabs UI and requires extra work - and teams may implement similar-but-different UX for this as they see fit. If we provide a built-in mechanism, we can still allow custom solutions but have something available out of the box.

Design wise, this is likely to be expected "inline" with the Tab Titles, not supplied as UI around Tabs as is currently required. I suppose this could also take the form of a "Tab Title content end / start" Slot - but it might be tough to ensure good alignment and visuals there...

Relevant Info

An example custom workaround, which helps solve for the issue but is a bit separate from the Tabs UI (and could still be relevant / valid if this display type is not opted-into):

https://codepen.io/mac_and_cheese/pen/dyajmZe?editors=1100

https://github.com/user-attachments/assets/0671020c-5e8d-47b9-afe7-9b83a18f0d3f

Which Component

Tabs

Example Use Case

Feedback from MV

Priority impact

impact - p3 - not time sensitive

Calcite package

[X] @esri/calcite-components
[ ] @esri/calcite-components-angular
[ ] @esri/calcite-components-react
[ ] @esri/calcite-design-tokens
[ ] @esri/eslint-plugin-calcite-components

Esri team

ArcGIS Map Viewer

Esri / calcite-design-system