Non-invasive neuromodulation technology is important for the treatment of brain diseases. The effects of focused ultrasound on neuronal activity have been investigated since the 1920s. Low intensity transcranial focused ultrasound (tFUS) can exert non-destructive mechanical pressure effects on cellular membranes and ion channels and has been shown to modulate the activity of peripheral nerves, spinal reflexes, the cortex, and even deep brain nuclei, such as the thalamus. It has obvious advantages in terms of security and spatial selectivity. This technology is considered to have broad application prospects in the treatment of neurodegenerative disorders and neuropsychiatric disorders. This review synthesizes animal and human research outcomes and offers an integrated description of the excitatory and inhibitory effects of tFUS in varying experimental and disease conditions.