My very rational reasons:
* I oppose any state owned firm from outside the US owning anything in the US as a matter of core principles. If we are a free nation, and believe in capitalism, then it is hypocritical to engage with non capitalist "businesses" that are not businesses at all, but are instead, fascist elements. I use the world fascist with care. I use it to depict an economic activity controlled by a government, not shareholders or private individuals.
* Although the UAE have come far vs their ways of the 1990s and appear to be cooperating in aspects of the WOT, I personally do not judge (OMG, there's that un PC word that drives liberals mad!) them to have a sufficiently long track record or sufficient transparency to fully trust them.
* The manner in which this has been handled leads to many questions, which even a 45 day investigation may not be able to answer. While I seriously doubt that there was any wrong doing, I also think that the due diligence may have been lacking.
How's that? Not very emotional, by my, oh here comes that word again, judgment.
Your second point, is once again based on your FEELING about 'how far' the UAE has come. People with far more factual information than you have (e.g. the U.S. military) have determined that there would have been no added threat to our national security.
Your opinion about how it has been handled is also based on FEELING. You may be right about your feeling, but it is a feeling nonetheless.
As I said previously, there is no logical rationale to oppose the deal. But as you aptly proved, plenty of emotion to base your opposition to it on.