In the US,
Leon is considered an old man's name, but not in a classic-timeless kind of way. It's more akin to
Elmer or
Floyd than it is to
Henry or even
Arthur.
Zoe Cecilia is very hissy and sibillant.
Zoe has a totally different vibe than
Leon.
Zoe is very trendy now, and
Leon is rarely used.