Right now the Has Opp filter allows you to see all opps associated to that individual. There are a number of times that you want to suppress or just filter all contacts at ACCOUNTS with an open or closed opp.
We had a similar issue – sales reps wouldn’t assign contact roles to opps which made it impossible in marketo to filter by the "has opportunity" field + get a good idea of our FT/MT attribution in revenue explorer. We looked into options and found Magic Robot (http://magicrobot.com/), which works great. It automatically assigns contact roles to opps, which allows you use the "has opportunity" field and solves the FT/MT attribution issue.