Didn’t know about the trickle charging, neat!
Problem with attaching a load is that if you want to build a standalone unit with the nest, you’ll need some type of inverter when powered off DC, or perhaps a simple sine wave generator? I’m more of a digital, DC power guy.
To attach equipment, you can connect a 24VAC-friendly load between (e.g.) Y<->C or W<->C.