In "The Stairs of Cirith Ungol" Frodo had suggested to Sam that Sam too was a
"hero" of whom tales would be told. "Samwise the Stouthearted" Frodo
said. Sam is embarrassed by this, but clearly the suggestion
sticks. Sam, too, wants to be a hero of a tale.
So, to add just a bit to your comment on the Ring's
temptation of Sam: the Ring seems never to produce a vision which the wearer
does not already have. It takes such a vision and reflects it back in a
more intense form. As to its tempting powers: does the Ring simply
magnify what is already in the heart of its wearer? It's just bringing
out inner desires and increasing their power?
From a certain point of view, the Ring can be seen as
having no real thoughts of its own, just its wearers'
thoughts.
_______________________________________

Although Frodo -- mostly to spare the old wizard's feelings -- recorded another version of the story, at the entrance to Moria it was not Gandalf who solved the riddle of the inscription, or indeed who found the door.