There are not "great" beacon mobile based product, because by OS design, beacons are meant to be restrictive. If not, it will be push messaging SPAM galore!
That said, there are really good situations on where to use beacons, those apps are being used, but they will not be world changing because it serves a narrow market, as intended. That's not to say there's no space for improving.
Answering your question, check out what the NFL has done, specifically, the 49ers mobile app with their stadium.
Cheers!