I can't speak from personal experience but a 75yo friend just had his second hip replaced and he tells me the experience was markedly easier in every way than his first replacement. As others have said the technology and the techniques improve constantly.
The replacement released him from constant nagging pain and difficulty sleeping. He rides a R110RT and although he doesn't ride often he rides it well. No off-road but he is considering buying an 1150GS Adventure so he may have some dirt road plans in mind He rides a push-bike and plays bowls for exercise.
Good luck with your operation and I hope you have many years of safe riding in your future.