I would like to create a Salesforce opportunity from Marketo based on a trigger from an email campaign. For instance, if a person clicks a specific link in the email then Marketo would push that person into SF and create a SF opportunity. Is this even possible?
Sure.
You could spend alot of dev time to use Marketo API to do this. It'd be better for Marketo to do the sync and/or change a flag that causes Apex code to Convert the Lead and Create an Opp.
Why would an email click cause an Opp? Usually Sales controls that more.