I think Boromir holds the ring in the movies, but I don’t think he did that in the books. Either way, he doesn’t turn invisible in either medium.

There are a few ring-wearers that don’t turn invisible when donning the ring: Sauron, Isildur, and curiously, Tom Bombadil, on whom the ring seems to have no effect.