Sure it's 100kWh in a year, so it's a few bucks per month saved. But in reality it's likely even less than half that saved, because the majority of the time it's probably not under transcoding loads.
Constantly turning it on/off will probably kill the disk faster than the power savings can make up for it, compared to just having it idle when not actively used.
Consumer harddisks are made to be spinned up and down occasionally. Don't do it every five minutes... But I've been doing it for years and years with my server that spins up the disks once or twice a day, once I access some of my archived files. And it's perfectly fine.
Yeah, don't let the bashers get you down: wasting stuff just because it's cheap is how we got here. Measuring your power use is the only way to make informed choices, and sometimes the results are surprising.
Like, I was surprised to find that my audio gear uses exactly the same power whether it's playing or not. The subwoofer alone uses twice as much power as the RPi that feeds it signal. It's maybe 0.02 USD/day (for the sub), but I've got extra smart plugs from a multi-pack, and it's easy enough to put together an automation to power them all down if they've been idle a while.
Don't get me wrong, I'm absolutely in favor of small wins, but it's important to not miss the forest for the trees. For example, don't throw out good hardware just to save a few watts. If your goal is to help with climate change, there are much better ways to spend your time than cutting a few watts here and there.
Fair enough. But even if you don't run on PV and actually do transcode 24/7/365, it's still only 5€/month. They idle at around 1/3 to 1/2 that though, which is arguably better for the disk than being turned on/off all the time, so you still get the bulk of the savings while extending disk lifetime.