When should you tune up query performance?

i've been running into some slow api endpoints lately, and it seems like the database queries are the culprit. we've got indexes in place, but some queries are still taking a few seconds. when do you all typically start thinking about deep query optimization versus just adding more resources to the database server or introducing a caching layer? what are the signs that point towards query tuning being the most effective first step