Yeah I don’t think weights or water is very good for energy storage in this scenario. It works if you have large reservoirs with hundreds or thousands of feet elevation, but it has very little capacity on small scales.
Discussion
There are other options available. Maybe store energy by heating something up. Or just accept that you won't be running all the gadgets for some hours of the day. I actually do think weights will work fine - it would just take more weight if you hang it under the structure, due to buoyancy.