Sorting accommodation options by price alone misses the factors that actually determine whether a stay feels good or frustrating - location relative to what you're there to do usually matters more than a modest price difference.
A cheaper place far from where you'll spend most of your time often costs more overall once transit time and fares are factored in - both in money and in the hours lost commuting back and forth each day.
An overall rating can hide a recent decline in quality - management changes, maintenance issues - that only shows up in reviews from the last few months. Sorting reviews by most recent gives a more accurate current picture than the aggregate score.
A full apartment makes sense for a longer stay needing a kitchen and laundry; a hotel makes more sense for a short stay prioritizing convenience and services. Choosing based on trip length and needs, not just what looks nicest in photos, avoids paying for amenities that go unused.