I said
That sounds as if you want Hugo to provide relational database capabilities
“Combining categories” is similar to “joining two tables”. Which is a key function of relational databases.
People have created websites with more than a million pages using Hugo..
From what you let transpire in your many posts, you’re dealing with dynamic data (real estate?). Lots of attributes (“categories”), having lots of possible values, frequent changes. It may well be that this doesn’t sound like “relational database” to you, but it does to me. You can, of course, drive in a screw with a hammer, but a screwdriver might simply be the better tool.
In your setup, you’d have to create all possible combinations up-front, never knowing if anyone will need them. In a more dynamic situation, you’d simply offer a search function and retrieve the data from the database if and when it’s needed. No need to generate millions of pages.