Not always - I can't see FOSS like Hadoop or Spark benefitting anyone except large corporations and (maybe) universities.
But in my opinion, any software being FOSS is benefitial, even if you cannot deploy it yourself for your toy projects. If anything, you get to play with it or learn from its source. Maybe parts of it are useful to you for your own project. You cannot do this easily (if at all) with closed proprietary software.