The first thing we have to do is find out how much acceleration is required to maintain health. This is a good reason to go back to the Moon. It might turn out that 2m/s^2 plus resistance training is enough to maintain reasonable health.
And, as far as I know, there have been no such studies done or proposed yet to determine a suitable minimal gravitational acceleration (with some counterbalancing human effort as you mention). Seems all of the attention is on how to spend 23.99 hours a day (sarcasm there) doing nothing but exercise to maintain health for microgravity environments.
No argument with you about this. My argument is that if we are to consider seriously any long-term space travel (the most likely to occur first would be to Mars), we must give up any notion of surviving in a microgravity environment. It is not possible. The current joke is that if the astronauts survive the microgravity and radiation (and whatever else) on a Mars voyage, their bodies will disintegrate upon landing because of the extensive degradation of bone and musculature. A one way trip to their grave on Mars.
So, why are we expending all of our time, money, research, and intelligence on Rube Goldberg machines that do nothing more than provide a less than minimal force to only partially stave off the effects when we should be actively working on ways to create artificial gravity? We are doing such studies for replenishable air, water, and food supplies (as they will be absolutely needed - can't take it all with you). Why the goofal here?
Artificial gravity solves a long list of problems:
1. Bone and musculature decay.
2. Blood flow.
3. Correct resistance to other internal forces.
4. Inner-ear nausea and disorientation.
5. General disorientation due to lack of 'up' reference.
6. Running water (showers, toilets, etc).
7. Sleeping, eating, and expelling.
8. Long hours of almost useless routines.
In other words, all of the comforts for which we are evolved and accustomed. The only two disadvantages of artificial gravity are:
1. No more free floating about.
2. Massive objects now have weight.
The best solution I've seen for this is to have the crew compartment on a long tether connected to the engines, so the engine unit would pull the crew compartment providing linear acceleration. When the system is coasting, the engine unit and crew compartment would be set spinning. There are no insurmountable problems with this. The chief problem would be to keep the reaction mass from frying the cable or the crew compartment, but that could be handled by having the engines point at a slight angle. It might even be an advantage, as if the engines were hot (in the sense of radioactive), it would be nice to keep them far away. Going from dragging mode to revolving mode has non-obvious details, but we have good computers.
This is the best proposal that I've seen (thanks for reminding me of it!). Again, these need to be lifted from the 'drawing board' and put into testing mode. Start with something small (using ants, rats, fleas, sensored robots, I don't care). But dreaming about this stuff and finding real solutions won't happen while were dreaming.