Diving into Song Lyrics with Large Language Models: Unveiling Metadata Insights and Fueling Video Lyrics Generation