You should have a read of
$1.
Personally I think the best treatments are going to be a combination of gene therapy and biological treatments. I.e. use gene therapy to code the mutated gene out, then transplant a new retina or alternatively implant a synthetic one. There is in fact already a gene therapy that is on the cusp of commercial availability for RP65.
Thing is there are, if I recall correctly, hundreds of genes that can cause RP, although about six account for the majority of cases. It's going to take a long time to develop therapies for all of those. Then they need to be prepared for the specific patient. Then there's the question of whether the therapy will simply switch the disease off, or whether it will switch it off and cause the cells to restart and repair. If the former, abd on top of that a retina transplant is required, that's another complexity, another treatment that's in its relative infancy.
So while I think effective treatments will exist in the future, I'll consider myself lucky if I see one for myself within 50 years (and I've one of the common gene mutations). As for cost, I doubt they'll ever truly be considered "affordable": the user base is just too small, particularly if such treatments are one off.