This extension may get you pretty close to what you're looking for: https://marketplace.magento.com/magetop-module-bookingonline.html
but there are certainly other booking, reservation, and event ticket extensions, like:
https://marketplace.magento.com/aheadworks-module-event-tickets.html
https://marketplace.magento.com/webkul-booking-and-reservation-system.html
Magento has a native In-stock Notification that you can use to alert shoppers when an out-of-stock product becomes available again, so that could potentially help with waitlisting. https://docs.magento.com/user-guide/catalog/inventory-product-alerts.html
If the products use native Magento attributes, then setting up search filters shouldn't be too difficult https://docs.magento.com/user-guide/catalog/navigation-layered-filterable-attributes.html
Similarly, you can you List mode instead of Grid mode to display these products.
Connecting Magento with an ERP like NetSuite requires a 3rd party integration. You'll want to consider if the extension you choose will cause any grief for that process.
For examples, Webkul has suggested that their extension taps into native Magento functionality, and is therefore compatible with Magento's native REST API. "Product listing, add to cart, ordering, payment all are base features of Magento. Our module does not affect it. It will work as the normal product of Magento using REST API.".
Similarly, AheadWorks has written that "Yes, the extension contains REST APIs and is ready to be integrated into PWA, SPA, and other solutions with modern and efficient frontend interfaces."
If the extension uses Magento's native product features, it's likely compatible with Magento's native product import functionality https://docs.magento.com/user-guide/system/data-import.html
Additionally, you may be able to not only sync order data to your ERP, but actually build out the products in your ERP and have them sync to your Magento instance.
Depending on your ERP, you'll want a solution to connect seamlessly. If you're working with NetSuite, there are companies that typically integrate these systems like nChannel, eBridgeConnections, and Celigo.
You or your Magento developers should further vet the specifics to make sure that you have a solid project plan, but chances are that, you can get pretty close to the functionality you're looking for with an extension + native Magento features + some design work to lay it all out nicely.
Best of luck!
