Great post, having recently joined Hive with a flurry, half expecting to make my millions in the first night, whilst having some crypto experience told me this wouldn't be the case.
Hive is a great platform to grow on, both as an individual and as a creator, it has a great way of cutting down those looking for quick fame or money. As you say, it seem to be more important to find your niche and what you enjoy and roll with that.
And as you suggest, I would also recommend people "see the opportunities", be prepared to dip your toes into some "new" niches, who knows what you might enjoy! There's endless possibilities on Hive for those willing to learn.
Those looking for quick fame or money are going to leave as fast as they came as disappointment will be big for them.
That's the only way. Also being open minded, instead of pushing what you want is key here.
You nailed it.