Hi Kevin,
There are a lot of consideration when using SFDC campaign influence reports - but what may seem like a limitation to one organization may look more like a feature to another - so it's difficult to generalize.
I have a lot of experience with SFDC campaign reporting, including RCA type reports but in SFDC and would be happy to share what I've learned. Feel free to reach out directly on my LinkedIn or at grant.grigorian@gmail.com.
Thanks!