You should have given DS9 a bit more time. It really picks up with the last episode of season two, when the Jem’Hadar are introduced.
As for the “things broke space station” - you’re partially right. But seeing a “Year of Hell” DS9 week for week would also have gotten boring in the long run, plus: Miles is a great engineer, maybe even better than Chief in BSG
One more thing: the concept of having a space station instead of starship did work for DS9 most of the time, sure, they introduced the Defiant so they could go off and explore new places, but most of the time it’s really about character development and character growth: they CAN’T just switch on the warp drive and fly to the next planet, they really have to deal with the bad things happening to them. Take Sisko: he falls in love with a woman and he has to make the relationship work, totally unlike Kirk or Picard who could find a new lover in the next sector. Or the way Nog has to handle his post-traumatic stress syndrome after facing combat. Or Odo and Kira’s relationship. Worf and Dax. Garak and Bashir. Bashir and Miles. The dramatis personae of DS9 are such a close-knit group because they’re on a station and around each other all the time. And the dominion war story arc is the best thing Star Trek has ever had to offer, definitely worth catching up on.