[Feat]: sp-dialog: add property to skip auto scrolling

[spdev3000]

Code of conduct

• I agree to follow this project's code of conduct.

Impacted component(s)

Dialog

Description of the requested feature

As we sometimes use dialogs with "internal" scrolling, such as settings dialog with a side nav on the left and a content area on the right, we take care of the content scrolling itself.
But currently it's setup in AlertDialog.shouldManageTabOrderForScrolling() that it adds: overflow: auto; automatically based on offsetHeight < scrollHeight, see:

spectrum-web-components/packages/alert-dialog/src/AlertDialog.ts

Line 152 in 4fd414b

public shouldManageTabOrderForScrolling = (): void => {

We'd like to have a property/attribute like skipAutoScrolling or similar that prevents such feature and "preserves" the css value:

.content {
    overflow: hidden;
}

Mockups or screenshots

Implementation notes or ideas

No response

[najikahalsema]

SWC-670