The gastrointestinal tract is colonized by trillions of different microorganisms, named the gut microbiota, which is key to degrade undigested food such as dietary fibers. The fermentation of these food components leads to the production of short-chain fatty acids (SCFA) acetate, propionate, and butyrate, which exploit several beneficial roles for the host’s health. Their production and absorption happen in different ways in the human intestine and depend on the type of dietary fiber reaching the gut and the microorganisms involved in the fermentation. The supplementation of SCFAs, mostly butyrate, in treating gastrointestinal, metabolic, cardiovascular, and gut-brain-related diseases has been reported in the medical literature. This review aims to give an overview of the production and absorption dynamics of acetate, propionate, and butyrate in the human gut, with a final focus on the role played by these SCFAs on gastrointestinal and metabolic health and the present therapeutic implications.