I had a front line wizard in The Dark Eye. Dude had trash spell stats but high strength, lots of points in throwing weapons and an indestructible crystal ball that he could summon back to his hand. Which counted as a magic weapon because, well, it’s enchanted.

And he still had access to various divination spells. Not reliably but still.

Playing a shit spellcaster can be a lot of fun.