Personally, no one tops Connery, but I like Graig, Moore, Dalton, and Brosnan. Something that helps is that each Bond is a product if its time and decade. Connery is the 60's Bond, Moore 70s, Dalton 80's and Brosnan the 90's, and you see the differences in the tone, look, music, and sometimes even the villains and stories. Each Bond forever cemented in a time capsule, which helps make each version unique and easier for the audience to embrace. Bond remains mostly the same, with minor changes and differences in personality traits that are inherent to the actors playing the role. Connery was obviously smoother and cooler than Craig. He also didn't mind slapping women a little, but he was charming and good natured despite his "male chauvinism", again, that's all Connery. Moore was more sarcastic and the most British of them all, almost snobbish in the way he acted. They're all different enough in personality and look, but the core elements of Bond remain intact. He fights, then he f****s, because that's his reward. That's his pattern in every single movie. He also gets captured a lot too, but no one ever shoots him, because all the villains are above such methods, and it's disrespectful to Bond. Props to Red Grant in From Russia with Love, he was just going to shoot Bond, but he got greedy.
As for Indiana Jones following a similar formula with different actors, it can work, but the question is, should Indy be forever stuck in the 1930's and 40's or like Bond, should the time and setting be updated, making it easier for the audience to accept a new actor in the role while keeping the previous version in a sort of time capsule like Bond? Indiana Jones is very much a product of his time, and I don't mean the 80's, necessarily. The time jump to modern times might be too jarring for most people, but it could help. Just look at the Uncharted games. Those are modern takes on Indy adventures and they're awesome.