One confounding factor here is that it's quite hard to draw anecdotal conclusions, because it is impossible to test the counterfactual; the YIMBY would make the case that rents would have gone up even more in Portland if the fishtanks were not built.
And the effect is quite hard to measure; that paper I linked says "I find that monthly rents fall by $22.77 - $43.18 relative to trend, or roughly 1.2 - 2.3%, for people living within 500m of a new project" -- this is probably not noticeable by you or me with anecdotal observations, but if the study is correct, and we committed to lots of new buildings, then it could make a noticeable difference in aggregate after lots of new projects were completed.