So, in summary, binaural beats certainly do not work the way the sellers claim, but there's no reason to think they're any less effective than any other music track you might listen to that effects you in a way you like. If they make you sleepy (like they all do for me), use them to go to sleep. If they relax you or get you amped, use them for that. But don't expect them to be any more effective than regular music. If someone you know claims that they are, put them to the test, and bust the myth.
If brainwave entrainment leaves you with unwanted side-effects (see below) or discomfort, you’re probably encouraging a range of brainwaves that are already excessive in some area of your brain. The way around this is to get a brain map to see what your brain’s strengths and weaknesses are, and see what (if any) brainwaves could use some encouragement.