Map series scale bars settings for maps with varied scales

[Psoralea]

Hi I regularly build map series using ArcGIS pro, and usually everything is sweet, except I sometimes struggle to get scale bars to behave.  For example I would like to have a map series with with an Overview  map (e.g. 1:180000) showing a study area, and then the following Detail maps (1:5000).  However I cannot seem to get a suitable combination of scale bar settings that provide an acceptable scale bar for the series.  See examples below.  Usually I revert to creating separate layouts for Overview and Detail.

Any suggestions?

I think what would be helpful is to have scales that are visible depending on the Map Series page number or similar?  Like Page queries for map layers.

Overview map scale 1:18000

Detail map scale 1:5000

[Psoralea]

Using 'Adjust divisions and division values' I get the results below which are not useful  - there is no way to force the numbers to be useful

Overview 

Detail

[KellyLyons_2]

Esri - do you have any response for this? I have had the same question for years. The scale bar functionality is not sophisticated enough for map series with pages of different scale.

[JohnLloyd__SHA_]

I second Kelly's comment here.  Scale bar needs to be added to Dynamic Text and/or Graphic section somehow.  Currently, you cannot have an accurate scale bar in a map series that has varied scale between index features being showcased.  The only way to accomplish this is through Dynamic Text related to Map Frame extent (1 to "Whatever" or 1:Whatever).  Esri PLEASE - help us out here......