Fractured mine years ago (at least I think it was the schaphoid). Usual 6 to 8 weeks as I remember, though cast was on longer mainly due to long wait to get a fracture clinic appointment to remove it. Over a decade later I still get wrist ache from time to time, and it used to even seize up and couldn’t bend the wrist, then it’s fine again a day or two later.
Someone I know I think was saying his had effectively died or some bit of it had! Not sure if he ever had an op for that.
Now I get a bit of wrist ache in the other hand from my off a few months back. Fractured fingers but ligaments are the main issue. Doing physio to get things bending properly again and it’s almost all back to normal, though aches when clenching fists, but wrist sometimes aches too briefly.