[ENH]: add_collection(..., autolim=True) should update view limits as well #29957

Problem

Axes.add_collection() has the parameter autolim, which updates Axes.dataLim, however it does not update Axes.viewLim. This requires an explicit ax.autoscale_view() - or when using it internally, we use the lazy ax._request_autoscale_view.

Proposed solution

Axes.add_collection(..., autolim=True) should itself call ax._request_autoscale_view(). If we opt into limits handling, this should possibly include the view limits as well. Requireing an extra call from users is cumbersome. Also since ax._request_autoscale_view() is private, users can only call the eager ax.autoscale_view().

Todo: Investigate how to make this work correctly for 3D, which seems to use a dedicated auto_scale_xyz().