I think Frieza is a great villain as his motivation was clear: become immortal and rule the world. Cell saga was good, but what was his purpose...to become perfect? Broly was just annoying.
A huge issue making Frieza a credible threat again is that everyone has already powered up well...