When they say, "Not all bees create honey" they're referring to things like masonry bees, or carpenter bees. All honey bees produce honey - and those are most certainly honey bees.
You have a wide range of people and as wide a range as why they keep their bees. For me, I started for a series of reasons.
1.) Premature Rheumatoid Arthritis - Bee stings could potentially help with the symptoms.
2.) The honey - I wanted to try my hand at making mead (honey wine) and honey is expensive!
3.) I like honey - Most honey found in stores isn't "real" honey
4.) I like to experiment - Ultimately, I will be doing experiments with my different colonies to check on some of my theories on why beekeeping seems harder for some than others.
Other people are all about the honey. Some people focus on just the wax, and don't even collect the honey. Some are after pollen, while others want the propolis. And some just like the fact that it significantly helps the environment.
It all depends on what your own driving reasons are for becoming a Beek. I will say, once you've got it started, and you get into doing the research (bees are absolutely fascinating creatures) you'll find yourself keeping more hives than just the one in no time!
All of this said, don't expect to be turning any significant profit with your bees until you have a hundred or so hives, and have gone straight commercial. However, it's not unusual to get a hundred pounds of honey or so from a strong hive every year.