Cloud was certainly a popular and iconic enough character to be in Smash, and I think he fits well. That being said, you can't know who won the ballot from the DLC characters chosen. We don't know anything, other than King K Rool, Chrom and Dark Samus were supposedly high on it, as claimed by Sakurai, as well as inferring from Mii costumes. And there's evidence to suggest Bayonetta was chosen before the ballot finished--since she was the final DLC character, the same could be said of Cloud. As for the evidence we do have, the
fan polls, Cloud was popular-ish, depending on how you analyze the polls (for me, I'd say he was popular).