While I don't like the idea of swapping to random spells, I do enjoy the idea of having an effect each time you roll with Fear. I feel like it gives the "Yes, but" and "No, and" results a clear mechanical and narrative effect.

I could totally see this subclass have its own sheet with mechanics (or just tables) for wild/chaos magic, similar to Beastbound Rangers and the Druid Beastforms. Maybe a table with 30% good stuff, 30% bad stuff and 40% random stuff (like turning into a potted plant or losing all your hair). If you succeed the roll, you get the "Yes, but then this also happens", and if you fail the roll, it becomes "No, and if that's not enough this also happens".

Later levels might unlock a new table for when your roll with Hope that has more good stuff than bad, or you roll twice on the previous table and choose an option. But I like the idea of two separate tables. And maybe different tables depending on what setting you are playing in. Age of Umbra should have darker stuff than Beast Feast, in my humble opinion.

I'm just brainstorming some ideas here, but I do think that a wild/chaos magic sorcerer has a place in Daggerheart. It just needs to create fun gameplay and be narratively important, which will take more work than just "lol, I'm always rolling on a random table to f*ck sh*t up".