It has many, many upsides. With the only true downside being the skill needed to operate.
Manual transmissions aren't going anywhere. Yes, the latest greatest $35,000 car that average Americans are buying will always be an automatic. But for trucks and cheaper cars they will always be the best choice.