I used to play it, still got the discs.
If you want a challenge, try going into the create a mission mode, giving yourself a single excelsior class ship and going up against seven Klingon supercruisers.
That's fun. And actually doable quite easily if you know the trick. (You gotta disable the one that's furthest away from the others and then tractor beam it so you can ram the other ships with it. It destroys the two ships very quickly.)