What I would share is that in the couple of years I've been running it, I've been through a dozen Sandisk and Samsung MicroSDs on my Pis _even though_ I was running my time-series database, and my MQTT server on a separate server.
Running on Raspberry Pi it's a nice toy, but when you get serious, install it on a proper box with an SSD/spinning rust.
I bought a NUC-like device which is what most people will recommend to run it on, installed Arch (you can use whatever you like, Debian is probably best supported) and get going.
Briefly though, I log all of the temperatures and light levels in each room of my home using Z-Wave sensors, store them in Influx and graph them in Grafana.
I have my desk lamp turn on when motion is detect at or around my desk, I have my cameras start recording when nobody is home (based on location reporting from our mobiles using Owntracks back to my self-hosted MQTT server).
I have hue lights in every light socket in the home so I can switch them to various moods based on motion, time of day, lux, whether the TV is on, the weather, the temperature, etc etc.
The Home Assistant dashboard shows my server load in my rack , temperature in my rack (via a temperature sensor connected to an ESP8266 talking MQTT back to the server), all info on my UPS, load on various power meter wall plugs (Z-Wave) which can also be controlled on/off via HA, it shows the current temperature and light level and motion in each room via Z-Wave motion sensors.
Most importantly, the community that sit on Discord are a friendly and helpful bunch so it's nice and easy to get started.