No only low quality journals will make you pay in general
It's bifurcated. In the past, author fees were associated only with predatory journals, and thus were stigmatized.
With the entry of legitimate open access journals to scientific publishing, author fees became more widely used and accepted.
More recently, higher impact journals that originally functioned under the old model of subscriber-pays realized they could parlay their prestige factor into a cash grab. First they started step-down open access journals with huge author fees (hey, sorry, your paper isn't quite good enough for Molecular Psychiatry, but we'll kick it down to Translational Psychiatry for a marginal prestige reduction and the low low price of $3K in author fees).
Eventually as the author fees became even more normalized, they realized they could even charge them on the original flagship journal, regardless of open access status.
Now you can pretty much count on paying an author fee, not only for a predatory journal, but for almost any high impact journal or for any open access journal regardless of impact factor. There are still a bunch of solid mid tier non open access journals that don't charge them, because they have too much competition and their impact factor isn't high enough for most authors to swallow the $$. But scientific publishing as a whole is moving toward the author fee as an acknowledged standard practice, and at this point most people figure the cost into their grant application budgets.
Low impact papers like case reports are hard to publish without going predatory. Journal of Clinical Psychopharmacology still publishes case reports and doesn't charge author fees as far as I know, so that could be worth a try.
The best sniff test for a journal is whether it is indexed on PubMed. If it isn't PubMed indexed, odds are nobody will ever find or read your paper and it will just get buried. There used to be this listing of predatory journals
Beall's List – of Potential Predatory Journals and Publishers that was helpful as well, but I don't think it's being updated anymore so may no longer be very useful.