I agree that it's nice to make the middle name symbolic by choosing a person (family, literary, historical, religious) that's important to you. I also like a family last name as a middle name. (In my case, all my siblings have my mother's maiden name as our middle name.)
However, poetically speaking, I think it depends on the number of syllables in your last name and the way that they're stressed.
If you have a two-syllable last name, especially one that puts the stress on the first syllable, I personally like an trochaic triplet as I think it rolls nicely off the tongue, like:
Jonah Michael Hoffman.
A one-syllable middle name sounds fine (Jonah Mark Hoffman), but a three-syllable middle name (Jonah Jameson Hoffman) is a bit of a muddle.
If your name is one syllable, then I think you need at least a two-syllable middle name, for example:
Jonah Michael Smith (2)
or
Jonah Jameson Smith. (3)
(One syllable, like Jonah Mark Smith, sounds a little off.)
And, finally, if your last name has three syllables, you should pick a one- or two-syllable middle name:
Jonah Mark Harrison (1)
Jonah Michael Harrison (2)
(Jonah Jameson Harrison is a bit much).
Phew.