Exactly, there should have been much more of the Jedi in the third film - in fact in all three films. In the Clone Wars, a lot is made of the camaradarie between the Jedi and the troopers, if that had been prominent in the prequels it would have made the whole 'Order 66' thing much more poignant - instead it felt rushed, and without much emotion.
Definitely, nearly every friendship was never actually seen, even with Anakin and Obi Wan, it was all "Hey remember that great thing we did, arent we such good pals".
No one relates to it, its like me telling you about my close friendship with someone called Dave, you dont care because you havent seen it. We didnt see any actual friendship between the troopers and the Jedi, it was all implied, so like you say, when Order 66 came, it was almost like it had no weight to it. It was this huge thing, killing off hundreds of jedi, by the soldiers they had fought alongside for years, and it wasnt even slightly emotional because we hadnt ever been given a real sense that there was any bond there between them.
Now look what youve all done, now im ranting in here!
Oh while im here, Sam Jackson was awful, died like a bitch and like others have said didnt seem comfortable in the films. And yeah, the final battle between him and the two other jedi masters and Sidious was bad. Yes, I get it was supposed to show how powerful and skilled Sidious was, but you couldve had a great three way fight there, killing them off with incredible moves, then a final duel with Mace.
Like everything in the final film, it was rushed.