I concur. I used to handle a bunch of dealer network business for the big three and I think the number of workarounds and limitations might really get in the way. You can achieve some of the search functionality with third party engines like Algolia, Search360 and others. However the lack of conditional formatting on static pages is a pain in the you know what, and on CMS templates it is rather limiting sometimes. I have been looking at doing this to scale, but it’s just not there for me yet.
The Mixitup plugin (https://www.kunkalabs.com/mixitup/) has really helped alot of people solve seemingly unsolvable display issues with collections. That would be a good one to look at.
That said, you may be able to meet your requirements. There is a lot of information in the forums on various approaches that help remove lots of friction. You can always follow the model of some of the larger teams using WF. Design then push to the dev teams. That has been working for me.