I'm a little scared to hear all the horrible experiences with Magento because I'm a developer on our search team and working with Endeca (or any Oracle product for that matter) is an absolute nightmare. I flat out hate Endeca. We'll be due for a replatform in another few years (once the business gets sick of us trying to bolt on big data features to Endeca, which just wasn't built for such). I can imagine us going the Magento route since we already have hefty contracts in place with Adobe.
I've tried to pitch a custom solution based on Elasticsearch (or Solr directly) but my director and VP don't want to hear about anything that involves building various business user UIs from scratch. Endeca provides a (sigh... Flash based) UI that gets the job done, and on top of that we have several legacy apps with (can't believe I'm saying this in 2018) UIs written in classic ASP.
Other than Shopify or Workarea, are there any platforms you, the ever-full-of-knowledge gurus of HN would recommend? I really like both of the aforementioned products because they give you a lot of useful UIs out the box (in addition to the capabilities of the platforms themselves), but they also give you a lot of content management and we don't need that.