In this video, my Frigidaire fridge (model #FRS6HR45KS) had a mechanical failure on the water dispenser paddle. I was expecting to have to replace parts, but was pleasantly surprised that super glue worked.
Loctite super glue: https://amzn.to/3sU1l01
Water dispenser paddle: https://amzn.to/3pKV7gP