My first experience was very much like the OP. Hood time is nothing like actual IMC as you found. Good on you for actually flying in those conditions BEFORE your ride. I kinda wish I did more of that, though I had a little.
I love flying in IMC, or on an IFR plan in general. Especially on longer flights as it really does relieve the constant airspace, weather, TFR checking that you have to constantly do when going 1200 VFR.
I got my IFR in 2015 and flew my family up to NC for Christmas that year. Could not have made the trip if I didn't have my rating.
My currency is expired now as we have like 2 days here in FL where IMC is low enough to actually DO an approach in actual conditions. I thought about going up with a safety pilot and getting current as I'm in that weird 6 month soft expiration window but there's no point.
I'll probably renew it at my BFR next year, we'll see. Good luck with your rating and when you do get it, go up as soon as you can in actual again, by yourself. Nothing more challenging then flying to minimums single pilot IFR (for me anyway).
First IFR flight for me after my rating was to KLAL and I remember shooting the ILS to minimums and STILL not seeing the ground at 200 ft. That, was fun