I really apologize but I totally missed the notification of your message.
Just in case, I still leave a reply if you or someone else is still interested.
The search results can link to the details page, yes. This is easily done with the website property of each location or by using custom calls to action that let you add as many links as you wish.
The locations need to be added and updated directly from StoreRocket. For clients that have a number of locations, I’ve built a Google Sheets integration that let you (or your client) use a single Google Sheets document to maintain the locations. Once updated, it can be automatically sync-ed to the store locator, in real time. This has been very useful for both businesses and freelancers because you can just share the document to your client and ask him to keep it updated.
I totally understand your point in maintaining the locations directly on Webflow and having them updated on the store locator. It perfectly makes sense and you are not the first one asking about that. For this reason, a complete Webflow integration is currently under development.
Please let me know if you have any question, I just made sure to receive the forum notifications instantly.