yes friend that makes sense, standard managed switches should work, just set up connected to the router with port isolation

the setup for how switches connect to the router depends on bandwidth requirements more than anything, you could connect multiple switches to eachother as long as the link to the router can handle it

for a smaller operation with a couple hundred connections you should be able to get by with pretty normal networking gear and setups without anything too special