Cost: Awkwardness, potential for embarrassing rejection.
Benefit: Possible relationship, either short-term or long-term, with the subject of your admiration.
So in my mind, if you can get over the fear of rejection, there's no reason not to at least try. Coffee with a CEO is better than nothing, and may potentially be useful down the road. (Can I have a job? Remember when we had coffee that one time?) Likewise, a date with a beautiful model, even one, is better than eating ramen alone. Well, usually. :)
Also, while I agree with what you said about having "true value to offer", there are many types of value. When developing a relationship with someone like a CEO, you may not be able to offer them direct monetary value, but you might be able to give technical insight, an outsider's point of view or a perspective from a different industry, or even just a like-minded person to talk about basketball with.
My advice is to look hard for the value you can offer. Knowledge that you may take for granted is often quite valuable to others, or at least interesting enough for them to keep you around and ask your opinion.