Alteration's definitely a slow burn, but it does get better - just not the way you might think. The problem is you're right about the early stuff being tedious. Transmute Ore is genuinely not worth your time unless you're already committed to smithing, and yeah, Paralysis is locked way too far back.
Where it clicks is with the utility perks, specifically the one that lets you cast spells without interruption while moving, and the perk that reduces magicka costs. Once you grab those and get Mage Armor going (the perk that makes Alteration spells give you armor rating), suddenly you're tanky as hell without heavy armor slowing you down. That's the endgame appeal - it's not about the flashy damage spells, it's about being self-sufficient.
On Switch though, you're locked out of mods that would make it way more interesting (stuff like Ordinator completely overhauls the perk trees and makes Alteration genuinely fun), so I get why you're skeptical. Vanilla Alteration is... functional at best.
Honestly? If you're not feeling it by level 18, you're probably better off just ignoring it and going Restoration/Destruction like you said. Skyrim doesn't punish you for skipping schools, and your time is better spent on stuff that actually excites you. Alteration works, but it's not essential, and forcing yourself through spells you hate just to hit some endgame threshold is a good way to burn out on a playthrough.