Ross was another mixed one though, given his involvement with 31 and his initial response to the Derna situation at the beginning of the final season. He wasn't a male bee-atch or anything, but it did erode my respect for him.
Well I think for me, he was overall a pretty good guy.... sure he got sucked into the Section 31 stuff (I kinda liked the idea of 31 myself) and he may have had a conflict here or there.... all of the main characters in the show that we got to know very well through seven seasons all went through similar moral issues that we excuse away for the most part, because we seen more of the good things they have done.
Some examples would be Bashir's lying about his Genetics.... Sisko and Garak pulling the Romulans into the war.... Jadzia going off with the Klingons in their revenge.... Odo Ka'noodling with the Female Changling while the station was in occupation and his friends were in trouble..... O'Brian's prejudice against the Cardie-Spoon Heads......
If we never encountered these characters often in the show and then we're exposed to these examples of them, many might change their views of them.
But with Ross, compared to other Admirals through TNG/DS9, he stuck around, he was on the front lines, he'd sit and listen to what the crew had to say and would rarely pull rank to shut them up and do as he commands like other Admirals who rarely listen at all and think they're right all the time..... He married Sisko and Yates..... in a nut shell.... he was more involved.
Compared to Nechayev, he was more personal, one could relate to him and his position better and he was grounded.
Added:
Oh and in regards to the issue between the Bajorans and Romulans, Ross was put in a pretty tough spot where two allies were pulling him in two different directions. The Federation wanted Bajor in the Federation, but at the time, they needed the Romulans more because of the War and they couldn't lose them as an ally.... yet he also didn't want to screw over the relations buildup that Sisko worked on for the past 6-7 years.... as I saw it, he sorta did the Prime Directive thing and sat back to let the Romulans and Bajorans sort their crap out.... when in the end, he knew he had to pull the plug on this situation and forced the Romulans to turn back, thus he backed Kira and the Bajorans in the end.
If I was in that situation, it wouldn't be any easier for me I bet.