I think mine's a good news story.
In the evening after I broke mine I went kayaking. Well I tried to, but it hurt too much so I gave up. Was back paddling a couple of weeks later, though had quite a bit of pain for several months and ongoing issues with strength and flexibility for a couple of years - it didn't help that at the time my principle sport was canoe polo and it was my throwing hand.
A couple of years later after jarring it yet again and being in more pain I finally went to see a medical professional - both my GP and the doctor I saw in A&E didn't think it could possibly be broken until the X-rays came back. I was somewhat surprised to leave hospital in a cast having driven there (at least in those days hospital car parks were free). That was on for a couple of weeks which helped settle it down, but it was too late for it to heal by itself so I was booked in for an op a couple of months later. Spent the night in hospital pre-op, got my wrist shaved etc. and then when the consultant did his pre-op rounds in the morning he decided that I'd actually be better off leaving it alone as it wasn't generally that big a problem for me and he was worried he could do more harm than good. At this point the x-rays were showing cartilage around the malunion stabilising it.
Had some physio and was told I was likely to get arthritis by 30. Switched to paddling left handed (I actually did that a few weeks before the op as I figured I'd be paddling again quicker that way) which took a lot of the strain off, though I still throw right handed. The combination of looking after it much better meant it generally became pain free and much stronger, though I still only have about half the flexibility of the other wrist. 25 years on my scaphoid is still broken, but I don't have arthritis or any sign it's coming. Functionally I have very little problem with it though I choose to do some things left handed - which in a way is an advantage as apart from fine skills like writing I'm now fairly ambidextrous.
I'd not recommend following my course of not getting it treated for a couple of years, but it goes to show that it's not a complete disaster even so.