Yes, the United States should tax Wall street transactions as it would be an abundant source of tax revenue. Such revenue could be put to use for a bevy and a myriad of things. The debt ceiling may not need be continually raised if the United States had this new form of revenue.
Wall Street needs to be tightly regulated, and it needs to be taxed hard. In the past many years, financial institutions have gotten away with a lot. The firms have made risky bets on investments, and tax payers had to pay the price for it. A stringent tax structure would have led to less risky behavior.