Remember adding air to your Spyder's air bag does approximately four things:
1. Inflation increases the ride height.
2. Inflation increases the suspension stiffness in a complex relationship between the air bag spring rate, the mechanical spring rate and the ride height.
3. Inflation effects the geometry of the Spyder by raising the rear of the bike unless this is offset by an increased load to level it out.
4. Inflation will to some extent effect handling slightly due to item 3, the slight change in steering geometry due to 1, and the stiffness of the rear suspension due to 2.
So, mainly the objective is to add just sufficient air to have the Can Am designed ride height, depending upon the load on the bike. That's what the automatic system does, it reads the ride height sensor and adjusts the air pressure until the sensor reads the bike at its designed normal ride height.
Now, not wanting to make assumptions about your weight (I know I'm on dodgy ground here) and the luggage you carry, usually for a single rider I have found the pressure to normally be between 25 to 50 lbs.
Making the assumption you are, say, 140 lbs and without a passenger and luggage, I would start off at 30 lbs. If the bike feels too harsh at the rear over sharp bumps, I would come down to 25 lbs. I don't think you'll need to come down much below that. If the bike bottoms out over bumps (not the same as being harsh) and the rear bounces and floats too much, keep adding 5 lbs until it feels right. I'm 230 lbs and my solo pressure is about 50 lbs.
Part of it is setting where it feels right between bottoming out and feeling too harsh. But a lot of it is taste. Sometimes you might want to set it a bit harsh if you know you are going to load stuff on it at the store or pick up a passenger.
As far as I have read, the reliable limit is about 90 lbs/sq in. Do not inflate with a pressure tank or workshop compressor, like they use at a tire store, or even a tire inflation station at a gas station. The volume in the system is very small and it is easy to over stress it. Either a hand or foot pump, or a portable inflation unit that seems to take ages to inflate a tire. Note, every time you measure the pressure with a gauge you'll lose a few PSI too. On the automatic systems, the pump is very small and takes quite a while to inflate the system.
Once you get a pressure you like, measure the height of the center of the rear axle above the ground with nobody on the bike. Write that value in mm with a Sharpie on the inside of say the trunk lid. Then you can set the pressure any time by inflating to restore that height if you don't happen to have pressure gauge with you. It should put you in the ball park.
Note, remember to keep the tire pressures set accurately. Usually with OEM tires they run 20 lbs at the front, same each side is important, and 28 lbs at the rear. The rear tire pressure will effect the spring rate of the rear as it is part of the suspension so keeping a consistent pressure in the rear tire will help you be consistent with the suspension feel from the air you add to the air bag.
The automatic system just keeps the bike's rear at the Can Am designed ride height. With the manual system, you can adjust this up or down to a level you are comfortable with giving you an infinite choice in how the bike feels, which is both a blessing and a curse.
Good luck.
I hope that helps.