I think the same as you. Although I cultivate it mainly as a hobby now, I don't really care how much money it makes, but I'm happy with the little. Sometimes I power down, but only to invest in other promising projects, such as Zeniq. For me, this is a game that is enjoyable and fun, although I often have too little time to read long posts, translate them and write comments, and then translate them back into English. Hive account@castleberry pointed out to me that I should be more committed to the community. It is much more difficult to do this virtually, mainly because English is not my native language, and that is why I use translation programs (DeepL, Google).
Coming back to your topic, I think Hive can be a good pension supplement, but you shouldn't rely on it alone. It is important that creating content should always be a pleasure, not a compulsion.