Super powers? No, not really. The spiritual gifts mentioned in 1 Corinthians 12 are given to us so that we can present the fact that God is real to the world. We are bringing a "foreign" message to the world - the Gospel is a message from Heaven and about God, both of which we cannot see or touch. So, the Holy Spirit works through us supernaturally in order to show others that the supernatural message we are preaching is valid.