>I worked as a WordPress dev for around 3 years, and it nothing but misery
OK I'll just say it: it's because you were using shitty PHP. Unfortunately some of the most popular PHP-based platforms have terrible code. WordPress, Drupal, Joomla... they're awful. When I searched for a decent third-party CMS + framework a few years back, I eventually settled on SilverStripe. It's still a lesser known product, but I don't regret that decision in the slightest. Nothing is perfect, but it's the only platform I've found which actually makes sense when browsing the source code, and it's generally enjoyable to develop in.
Every time someone asks me for CMS suggestions, I tell them about SilverStripe. It's an open source, developer-friendly MVC framework and CMS built on an OO PHP framework. There are lots of modules available on Composer and it's super easy to extend with your own functionality. Also the UI for content editors is very nice and largely automatic, scaffolding off data models.
Hey,
I'd suggest looking into the lessons provided by SilverStripe - there is one on how to set up your local dev environment: https://www.silverstripe.org/learn/lessons/v4/up-and-running-setting-up-a-local-silverstripe-dev-environment-1. Otherwise the previously mentioned Xampp should do - it should work almost out of the box.
​
-- Peter
Maybe take a look at Silverstripe. They use templates, however, you are totally free to make your own design
It's a nice, easy to use CMS :)
You might find Silverstripe a good fit. Extending and configuring a DataObject
class in your code would create a table, then extending and configuring a ModelAdmin
class would provide you with a complete section in the Admin where you can manage the data (including importing/exporting features via CSV files - probably other formats too, I don't remember). Any relations between DataObject would be reflected in the Admin too.
On the other hand, the DataObjects also allow you to easily query and display data in your templates.
You might need some time to fully understand it, but if you'll find it potentially helpful at first sight given your requirements, it would definitely worth in the long run.
I've been working a lot with SilverStripe lately and I absolutely love it. It's a very modular PHP framework that comes bundled with a CMS. It's extremely flexible and you can do pretty much anything. They have some really good tutorials to get started, check it out here: https://www.silverstripe.org/learn/lessons/