Was the Death Star ever a good idea?

A lot has been said about what a waste of resources and manpower the entire thing is, but what of who actually controls it? Like whoever is overseeing the Death Star with their fleet essentially controls the Empire and not the Emperor.

It would be a tempting way to create a bunch of mutinies and destroy the Empire in the most deadly scenario possible.