I brought this up a while ago, the phasers on a Constitution are equal to those on an Intrepid.
As long as you play a ship in it’s intended era, the relative stats don’t matter…
…but if you don’t, Trek is all about time travel, then it gets awkward.
That’s the other problem. Post-TNG era ships get to the point where the stats are so high even in difficult tests there are often near-automatic successes. A Prometheus with SECURITY 5 and WEAPONS 14… the only things that stands in it’s way are that it’s phasers are only as powerful as a Constitution from a century ago.