Comprehensive review and assessment of multi-species splicing variant prediction: task-specific deep learning models and genomic foundation models | Synapse