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:
You can do better in the advanced reporting, though.
read this : Marketo / salesforce integration needs a serious overhaul, don't you "sync"?
Is this kind of query still not possible? I need this as well.