The aristocratic--if not haughty--Roderick has nevertheless pretty much always been in the Top 1000, reaching as high as Number 221 in 1967, when it was not uncommon to run into a Rod or a Roddy. It's at a low point right now, but we can envision it being revived as a neglected, dignified grandpa name.
Roderick has lots of literary history, including the novels Roderick Random by Tobias Smollett and Roderick Hudson by Henry James, and Roderick Usher is the main character in the Edgar Allan Poe short story "The Fall of the House of Usher." Roderick, of course, is the full name of Rod Stewart, and TV personality Rosie Pope called her son James Roderick.
Rodrigo, has a lot more verve, as does the Irish Rory.