Best hardware combination for HA?

Hello,
I am completely new to home assistant, and I am completely satisfied with it. What a great experience to easily create a dashboard and connect different platforms. I am an Industrial software engineer myself and I renovated my house 10 years ago and of course I wanted to automate everything haha. But then the best choice for me was to program my house in a siemens S7-1200 (knx system was too expensive for me). This has been working perfectly for 7 years now, and I bought a raspberry pi 3b+ 3 years ago to experiment with and to not expose my plc to the internet. Recently I was browsing on my raspberry and I saw Node-Red integration and I started experimenting with this and ended up on youtube where someone was talking about home assistant. So I thought I should try this too, and guess what I’ve been doing the past two weeks, just completely addicted to home assistant haha. But I have also completely grown out of my Rpi 3b+.

I think @brendan answer is a very good one that made me think for a while and actually you probably already answered my question what is the best choice at the moment. I have a Dell Optiplex lying around with an i5-6600T and 8GB RAM. And I took the same route as you to this guide:

https://community.home-assistant.io/t/installing-home-assistant-os-using-proxmox-7/201835?u=hert

And it now works great again but has to start all over again, but if it was worth doing the first time, it’s the second time to haha.

I hope this isn’t too long a post
greetings, Toine