I believe deeply in the concept, "Come unto me all ye that labour and are heavy laden, and I will give you rest." (Matthew 11:28)
One of my fondest memories of the often painful times trying to help a son deal with his struggles from an abusive past was sitting on the couch holding him as he sobbed. He was a full foot taller than I am and MUCH stronger, but I will treasure that moment my entire life.
You better believe I sit in church with my arms around my wife and as many of our kids as I can reach. My boys rested their heads on my shoulders occasionally in Priesthood opening exercises after a long Saturday night until the day they left home - and I hope they will allow me to return the favor when I use a walker to reach our pew.
All of us can be "comforters" in our own spheres.