The Home Automation category will appear as soon as any Home Automation applications have been enabled in the App Manager.
At the time of writing these are the available applications:
Home Assistant: open source home automation software that puts local control and privacy first.
Tuya Smart: support for all "Powered by Tuya" devices from a wide range of manufacturers.
More implementations might follow in the future.