I would say probably not since Sisko recommended that other ships of the Lakota's class not be upgraded with newer weapons for some reason having to do with more proven tech, though that was not fully explained.
There is no canonical dialogue which supports this statement.
Sisko never recommended anything pertaining to Miranda or Excelsior class ships. He did on the other hand have a hand in putting Defiant class ships into active service once the structural integrity was patched onboard the Defiant (as we saw a several of those in the Dominion War).
The Miranda's being upgraded make sense because SF upgrades all its ships in active service regularly (major upgrades occur once every 7 odd years if I'm not mistaken, and some smaller ones in between if the ships are near drydocks).
In TNG they featured up to date LCARS and I suspect the ships wouldn't be used in active service if they were sporting 75 year old weapons, shields, etc. (because that would just be plain reckless and stupid - I don't think people would be serving on those ships in the first place if that was the case).
The Lakota being upgraded by the time Season 4 episode 'Paradise Lost' gives us an indication SF took the Dominion threat seriously, and because they had a LOT of Excelsior and Miranda class ships in active service, it was probably easier to give them such upgrades than build new ships from scratch since most of the time this would entail switching out the Warp core for more powerful one, upgraded power conduits, shield generator, and modified phaser turrets.
Honestly, with transporters, the work is relatively easy for simple swap outs, while the older hw can simply be recycled.
Without being too negative, I think the people who worked on Star Trek just did not think that the general human population would be interested in artificial intelligence, or seemed to hoped not. That leaves fans with either saying that Star Trek has not predicted this, or that there is some reason that Star Trek ships don't use this tech much. Really, it seems like Star Trek would be less adventurous if artificial intelligence could do so many things for the characters, and "The Ultimate Computer" shows this could be the case.
I agree on the premise that Trek writers had a bit of a lack of imagination when it came to automation, but I disagree it would make Trek less adventurous.
Good writers make an effort to work with the technology in question and integrate it into a good story.
Since we know SF doesn't want to go 100% with automation, that leaves us with the obvious ways of integrating AI/automation to radically enhance different things such as:
1. Starship construction (this would easily benefit from 100% automation - and can be acomplished via combination of replicators, transporters and tractor beams).
2. Repairs, maintenance and upgrades - Discovery actually added DOT drones to the equation which actually fills up the role of assistive auto-repairs, maintenance and upgrades on the go (the ENT-D was said to be able to self-repair too, so there you go).
Its just that back in the 90-ies, they didn't really see inclusion of antigrav drones as a viable VFX option I imagine - or they never thought about them (but arguably, you don't need them technically, because the ships in 24th century would technically have the ability to repair 'wirelessly' via replicators and transporters for intricate systems).
In cases where the ship suffered damage and automation is not fully functional, the crew would obviously have to step in.
Looking at TOS tech, the idea that communities would simply things to make them easier to use if they do less does not seem like much a stretch. A TOS PADD is a good size for holding and not breaking if dropped, even if it does less than an iPad. If all its does is turn written text into a computer record that would still be able to advance to a much more effective level than it is now. And that could use a form of artificial intelligence, just not one that runs a ship. Of course these are also somewhat military-like settings so that means there would be different priorities from what civilians might be interested in using to determine what they want to use in their lives.
I suspect it depends on the use case scenario.
There's no reason to think the pads in TOS are any less capable than pads we use today... in fact, they'd probably be MORE capable... BUT, we're talking about a ship of exploration which uses specialized tools for different things.
Its possible that they just prefer to set these pads to present a specific data/information to not have to clog it up with other less relevant stuff - since people evidently work in specific departments.
So regarding drone Mirandas, if it got to the point that a ship that was once a major class of the fleet was now a disposable robot ship...well TOS says supposedly that does happen, and supposedly it happens to cargo ships, which the Miranda became...I was going to say that robot Mirandas would kind of ruin the sci-fi rules for Star Trek, but it suddenly seems more possible that I thought. Perhaps they are run for war by having a small crew of 5-7 like a shuttle mission with lots of automation and only artifical intelligence or drones unless the onbopard crew overrides it? Then a Miranda could carry 400 troops but not really have a very big "crew" technically speaking. The crew would be as small as 7 and be taking nearly 400 combatants to a planet to fight. Or maybe the crew will try to take over antoher ship

That would make them something like marines
As we saw in TNG, the Miranda's were still crewed ships - and there's no reason to think they weren't continued to be manned by living crews during Ds9.
They were simply upgraded with modern technology to make them viable in modern times because SF had so many of them in active service it seems - but either way, SF ships are designed to last 200 years at least... so, why would you have a ship in active service that doesn't have modern technology at its disposal?
During the Dominion War, I imagine that families on ships notion was rescinded for their own safety... most ships experienced a downsizing in ships crew compliment as a result, meaning that only SF officers would now be seen on those ships (at least while the Dominion War was in effect and on ships in active combat).
Apart from this, I would agree with the premise that despite the hw upgrades to older ships, they may have relied on more automation than more modern vessels during the war, but sadly, we have little to no confirmation that SF turned them into proverbial drone ships to such an extent even during the war.