Yes, I’m aware of this and it’s unfortunate. But I don’t see how using a VPS could fix this.
Not VPS, but pre-bundled and preconfigured image where most options and setting are set already up. Above i’ve mentioned the bitrix. For a long time they been very niche-ish product, but last 2-3years they did a huge leap on the market. Talking with my friends (either experienced programmers either merchants) i’ve figured out that this happen thank to making that preconfigured image, greatly reducing deployment time and maintenance costs.
Especially on a local setup she has all the powerful knobs at her disposal
I tried to help her, observing the apache config and local .htaccess via TeamViewer - and i have no idea, why this damn 404 appears when SEO torn on. Even TB’s automatically generated .htaccess doesn’t affects this issue.
Summarising, i see the situation following way:
If you developer or hacker-enthusiast, then you don’t need neither bundled software, nor VPS/DS.
Contrary, if you merchant/businessman then you don’t care much about apache/system tuning - all you need is the turnkey solution.