Fioricet is a trusted medication for relieving tension headaches and migraines, combining acetaminophen, caffeine, and butalbital for fast-acting relief.