Ideally I'd like to go off grid as it's the delivery fee that costs the most, and not the usage.
Yep. If you have running water microhydro might also be an option, depending on just how ugly the freeze-thaw cycle is where you are. In Aotearoa I got lucky on my ~100 hectare block with a small catchment towards the top of a hill which gave me a reliable 10 litres/minute but at ~80m of head. Power = flow times head, and you ideally ant one number to be much bigger than the other. But if your "small semi rural" is 1000m2
that's unlikely to be an option.
Solar panels themselves are becoming relatively cheap too.
If you're willing to bodge it you can likely buy second hand systems for next to nothing. Just beware of the US "assemble your own panels by bedding cells in epoxy" things that are too horrible to discuss. You want proper glass-fronted, manufactured panels. But with those and a willingness to run several inverters you can end up with a local mains bus that you can use for whatever. Viz, buy several 1kW-3kW systems and combine them. But don't try combining random panels on one inverter, it's not going to work very well at all. The electronics is not too hard, it's getting that system certified to connect to the grid that is ugly.
But wind... just say hell no. I have a friend with an off-grid property and even with two little turbines ~100m from the house they're annoying. Worse, one is bolted to a corner of a big tin shed, so when that's running you get the full on "next to the speaker stack at an ACDC concert" effect. The turbine shakes the pole, the pole is bolted to big sheets of tin... YEEEEAAAAH THUNDER!!! Don't do that.
The other turbine is a tilt-up pole with a 2kW turbine, and it's better but sadly the pole is only 12m high, so with 5m high trees and sheds it's nowhere near clear air. In a good storm the flow stabilises and you get 3kW until the thing trips out. Or, at about 150kph wind speed, falls over. Then you get to buy everything all over again. You need to balance "good wind exposure" with "what do I do when there's a storm".
Overall, he gets 4-5 times as much annual power per kilowatt installed from PV, and the maintenance is zero for the PV. Also, you can guess PV output pretty well using online tools but wind is so sensitive to microscale variations that the only way to guess output is to put dataloggers at the height you want and analyse a couple of years.