Attach view of content by author only to the user page
I haven't used this module, but according to the project page:

The placement of the view in the entity's content can be reordered on
the &quot;Field Display&quot; administration page for that entity, like other
fields added using the Field UI module.

So you should be able to configure this at Manage Display for users: /admin/config/people/accounts/display.  You can customize the display separately for Default and Compact, and you can create more view modes (different display configurations) as necessary.
Another way to do what you're doing (attach a view to users only on the user page) would be to use Layout Builder, which is included standard with Drupal.

Make a view that shows the user's content with contextual filters in a block.
Enable Layout Builder module.
On /admin/config/people/accounts/display, check Use Layout Builder, open Layout Builder, and then add the block.