Is it possible to run a smart list to show all contacts associated to an account with a specific type of opportunity, even if the contacts aren't tied to the opportunity in Salesforce?
not possible. Vote here:
SFDC/MSD: Enable to sync account opportunities (at least as a custom object)
You can do better in the advanced reporting, though.
read this : Marketo / salesforce integration needs a serious overhaul, don't you "sync"?
Retrieving data ...