There's always going to be a finite limit on total sites, regardless of whether it's Wordpress or Magento.
For Wordpress, it all depends on how well-behaved the plugins are for each Wordpress install. And I mean ALL depends as in it won't matter squat how well you've got the server...