Poorly conceived, badly written, terribly acted.
It always came across to me he only got the gig because of who his father was. He had little tactical wit, bigoted diplomatic skill, and no substantial scientific knowledge, all he seemed capable of doing was piloting a ship.
The writers tried to make him into a Picard-styles statesman with eloquent speeches, but Bakula just doesn't have the acting chops to pull them off. Giving him a dog was also pretty lame, especially when he takes it on diplomatic missions and onto strange worlds with unknown pathogens and parasites.
How he was supposed to be the "idol of Kirk" is laughable. Why would anyone want to emulate someone who gets their ass whooped every other week?