They are until they're not, at which point it's too late. I deal with things teetering on the edge.
At some point you get to machine sizes that won't fit in AWS as an example.
That's true of, well, anything. A non-RDS / NoSQL datastore doesn't save you here!
Modern relational databases are great at what they do.