I think I understand your frustration.
It seems to be the industry as a whole has not served this need well.
FPV tackles a relatively small part of the problem very well. The author intends to tackle more and I participate in this forum because I think FPV has a very bright future and will address more of these needs over time.
But you obviously want a solution today, if not yesterday
Personally, I think Adobe Lightroom comes closer than anything else to addressing the kind of workflow requirements you've described. It seems to be working well for some folks but it doesn't quite fit for others (including me).
It truly sucks that the all important Ranking field is the one item of EXIF/IPTC/XMP data that seems to be the least well standardized across different applications
Having said that, I should acknowledge that FPV does offer some pretty flexible options in that regard.