Cardiac myxoma is the most common primary heart tumor in adults, typically originating in the left atrium. It can cause symptoms due to obstruction of blood flow, embolism, or systemic effects, and is usually treated surgically due to potential complications.