The Automatically Scale New Drawing Views button is checked on my drawing template, the drawing template sheet scale is set to 1:1 when there is no view brought in, views are brought in at sheet scale, but the sheet scale changes automatically so that the view fits on the page. I think that's what you want but I'm sorry I can't find the setting that lets it do that, the drawing templates were set up by my predecessor. Maybe someone else can help.
But I do not want to add user defined custom sheet scale. What I want is,
a) while inserting a view the default setting should be Use sheet scale and
b) sheet scale should change automatically to accommodate the view
and all this should be in-built (without using macro). Is there any such setting?