Do mini cacti grow into huge cacti?

It just depends on the genus/species, but if you bought a cactus from a home improvement store and it was small it will grow to be large depending on the genus/species. Most of the cacti sold at home improvement stores are cacti that grow to be large.