From Text to Transformation: A Comprehensive Review of Large Language Models' Versatility