The best medication for excessive daytime sleepiness can depend on your individual symptoms and lifestyle. However, modafinil is a stimulant medication that is considered to be one of the most effective drugs at treating excessive daytime sleepiness.