Contemporary Examples of the Holy Spirit's Presence
1- Baptism shows the presence of the Holy Spirit in a big way. Infact, we are directly connected to the Holy Spirit at that time. At baptism, the Prophet Ezekiel says that he will cleanse us with water making our hearts rid it's impurities. Leading us away from the impurities gives us a clearer sight of being one with God.
Ezekiel 36:25 "I will sprinkle clean water on you, and you will be clean; I will cleanse you from all your impurities and from all your idols."
2- An example of the Holy Spirit being present in the Church is when Pentecost approaches and we wait until the 7 weeks of Easter come to an end. We wait until Pentecost because once Christ's Passover is fulfilled, he allows the Holy Spirit to communicate as a spirit and "manifest" himself into our hearts.(Catechism of the Catholic Church; chapter 3 article 8)
Acts 11:15 "And as I began to speak, the Holy Spirit fell upon them just as He did upon us at the beginning."
3- I've had many experiences where I felt the presence of the Holy Spirit while in church. One key experience was my Communion. After a couple years of hard work and dedication in the church community, I was able to see where the work paid off. I was cleansed from my sins and made my communion. Although I've always felt something while going to church, it's been a different, special feeling ever since that day.