Raptor is by far the best engine ever built according to that measure.
Prometheus doesn't seem that impressive but we don't have all the information on it as far as I can find.
What? I am a casual observer but I believe specific impulse is most important - how much thrust do you get per unit of fuel. The amount of fuel you have to carry has a huge impact on how much. Of course things like ion thrusters have high ISP but not enough thrust for launch - but once you get enough thrust to launch a rocket, you want a high ISP. High ISP means way less fuel required which means even with less thrust you will be okay. So thrust per nozzle area isn't strictly that important if the engine is so inefficient you need to carry twice as much fuel.
Weight/thrust is important; thrust/area is important; ISP is important; thrust/dollar is important...
something more like that is probably the most important variable.
all the rest of them impress space nerds, the ones ending in per-dollar are the ones that impress accountants and finance people.
If you can not get enough thrust under your rocket sectional area, your capsule will simply not leave the ground and your astronauts won't make it to the Moon, independently on the accountants opinion on the matter.
All of those things are important.
High thrust to weight ratio is important for a rocket. The higher your TWR the less gravity loses your rocket suffers.
There is a reason most rockets main liftoff comes from lowers ISP RP-1 engines or solids rocket. High ISP hydrogen engines just result in losses.
SpaceX Raptor actually deliberately reduced its ISP to increase its thrust.
Also I think what they meant is that the engine's thrust dictates the height above it that it can lift. So lots of larger low thrust engines = short and stubby rocket, which adds all sorts of limitations (construction, transportation, aerodynamics).