The honest answer: effects, if any, tend to be modest and gradual, and vary a lot by ingredient, dose and person. No supplement is a substitute for sleep, exercise and managing health conditions.
Track objectively over several weeks, favour products that name their ingredients like NeuroRecall, and be skeptical of anything promising dramatic, fast results.