It depends upon the situation. If I drive past a Church with a beautiful statue of the Sacred Heart of Jesus, I’m not going to come to a screeching halt, run from my car, and prostrate myself in full view.
If I’m by myself and I’m going to pray in my home, I might prostrate myself.
Generally, I make the Sign of the Cross, often, even in public. One may adore in one’s heart only. If, by public actions or words, others will mock or curse God, then it’s best to offer silent adoration.
This is even cultural. I grew up in NYC when there were still very ethnic parishes. If you went to Mass in the Italian parish, it wasn’t unusual to see people kissing statues or prostrating themselves and praising aloud. The same behavior in my mostly Irish parish would have been considered highly improper and undignified.
Personally, I’m not a person given to public displays of worship, adoration, or emotion. I don’t judge those who aren’t like me. I’ve been around enough to realize there are all kinds of Catholics, and I’m not referring here to being “ecuмenical” in the Vat. 2 sense of the word.