Works Okay...
I did exactly as you are thinking, when I was working on my fuse. I would say, it worked okay. Honestly, it was handier just to have the casters (at times) than to use the rotating feature. It is not easy to mount in the aft end so that it will rotate nicely. What I found was where it hung nicely, and worked well with the stand, it had a very low center of gravity in the rear. Thus, when you rotated it, the weight was WAY off to one side. I could get about 25 to 30 degrees of rotation, then it was starting to get to where it was very unstable, and could fall over. The firewall was very easy to mount, but I found that the stand upright was not quite tall enough to allow clearance for the fuse to rotate with out hitting the base horizontal legs of the stand. The other problem with them is the lack of locking casters. When working alone, and trying to buck a rivet that is not the easiest to get to (which in my experience was about 75% of them) as I would get into postion to rivet, I would be leaning slightly on the fuse, and it would start to roll away from me.
If I was to do it over, I would use a stand on the firewall, and make some sort of adjustable padded stand for the tail, rotate it and set it on the stand at whatever height it required. And I would put locking casters on the stand.
Oh, one more thing. Most of the engine stands (especially the cheap ones like I used) use a pin and alignment hole for indexing the engine (fuselage) The problem is that it is never in the position you want it, it is either too much, or not enough angle. Plus, they are not a very well toleranced hole so there is alot of slop. A solution to this would be to weld a nut over the hole and use a bolt as a set screw for indexing, then you would have infinite adjustability. And make sure you use the stand with four casters and spread front wheels for stability. I used one on the firewall, and used a three wheeled one on the tail. All the time wishing I had spend the extra $15 and got both with 4 casters.
My honest opinion is that it does work, but it is not the best solution.