I hesitate to use the term "appropriate", but there are some names that I'm more comfortable with in the middle.i don't think they MUST be middle names only, it's not a hard limit.
Mega popular names from my generation are so boring to me out front, but in the middle they feel like a warm hug. Stuff like
Amanda,
Michael,
Christopher,
Jennifer, etc.
More daring names that might be harder to pull off feel safer in the middle. Also, names that don't "nickname" well. Things like
Petal, Orchid,
Ripley,
Posie,
Chalice,
Sparrow,
Goretti, Samhain,
Toussaint, etc.