So there'd be no upfront fees if, say, Melo Eggleston wanted to sign with an agent?
Nope, a real agent would never charge anyone. That doesn't mean an agent would ever accept Melo as a client.
if you are a marginal or lower player, it is highly unlikely that any agent would take you on.