SKT is definitely on the money regarding making the most of your ground tour. Tours can either still be related to flying operations (just not in a cockpit), somewhere else in the air force (a procurement office, perhaps) or in the larger CF venue (a so-called 'purple' job). They all have their ups and downs. Some folks may find it frustrating to be close to, but not doing the flying. Others may want to stay working in an air environment even if not flying. I have had all three types of staff tours and found them rewarding in different respects. In a flying headquarters, you can directly assist operations, a light blue staff job can see benefit go to the whole air force, or in procuring new equipment for a particular community, and working in the 'purple' world sees the reward of CF operations on a larger scale.
A very rough rule of thumb, but as a Captain, you may only have one ground tour for every two or three flying tours, as a major it's closer to 1:1, and as a LCol you'll be lucky to get one flying tour (CO) and the balance will be staff jobs.
Cheers
G2G