Cardiac rhabdomyoma is the most common primary cardiac tumor in children, often associated with tuberous sclerosis complex, and may spontaneously regress over time. These tumors are typically benign and can cause symptoms depending on their size and location within the heart, potentially leading to arrhythmias or obstructed blood flow.