I don't think it's shameful, though just niaeve to expect it to work well. To be fair I do think it is difficult to make a choice until you make an app of size

I don't think it's shameful, though just niaeve to expect it to work well. To be fair I do think it is difficult to make a choice until you make an app of size you will not know about those edge cases. My agency worked on a site which had ~1M+ pages and the backend became unusable (entries table was dead), task management had to be bespoke, search had to be dealt with by Elasticsearch amongst other things.