I agree with both the surgery and the goldwing. Even a four cylinder goldwing is less vibration prone than a CB750, but the sixes are great. I rode a Harley (please, let it alone, I have heard it all) and the Carpal Tunnel along with tendonitis made it impossible to ride very much. I bit the bullet got the surgery, and bought a GL1800 and I ride 15 to 20 thousand miles a year now. We all get older, and when this sort of thing takes away from any enjoyment in life, get it F*&^ing well fixed. Life is too short to not enjoy to the fullest.
Warning: Carpal Tunnel repair will cause the loss of about 40% of strength in the hands, but with some rubber ball and hand exercise most will come back in time. Also, the scar is real tender using wrenches for a while, but constantly rubbing them will reduce them to just about flat and will eliminate most of the sensitivity. Being a millwright, both of the above were irritations, but have been overcome.