Is the Opportunity Origin updated automatically like the Lead Origin Field?

No, the opportunity origin field is not updated automatically. It’s a string field that takes the value sent via the API payload or via CSV import.

For more information, see Opportunity API and Import Opportunities.