Hi there Woodchip!
There are quite a number of airpistols that suits your need.
Anics A3000 Skif
The Anics is a russian made walther-lookalike airpistol that has a 28 shot rotary chain magazine in the handle. The gun shoots everything from pointed pellets to lead BB`s without problems. It has decent MV (sorry cant remember exact but i think it is around 130m/sec) and good build quality.
Now the main drawback of the Anics is its trigger pull. Again i dont know exactly how much it is but i would guess around 2-3kg`s of pull.
The reason for this is that the trigger interacts with the chain magazine, pulling it around for a new shot everytime you push the trigger, therefore it also has a good deal of creep.. The trigger pull can be lightened with some careful oiling of the chain to minimize friction as it goes around..
All in all the Anics is a good practice gun with acceptable accuracy. and you can rattle of the 28 shots as fast as you can pull the trigger. It also has very good open sights.
Its powerplant is standard 12 gram CO2 capsules
www.webcom.com/airguns/Anics.html TWINMASTER ACTION/ALLROUNDER/TOP
The twinmasters are german-built C02/PCP target pistols at reasonable cost. they are VERY accurate (7mm groups at 10m from a rest) and Weighs about 950 grams
The twinmasters is based on the revolver principle, you have a 8 shot rotary mag which can be fired SA/DA. It has a walther lothar rifled barrel and can be fitted with weaver/11mm bases for red dots, scopes etc..
The DA mode is allright, nothing more nothing less.. The SA mode is brilliant! you have a trigger with aboslutely no creep that can be adjusted from 500 to about 800grams.
The models exist in both Co2 and PCP (PreCharged Pneumatic) The clever thing with these guns is that if you buy the basic model (Action) which is co2 powerplant, you can "upgrade" it to a "TOP" (PCP) by just buying the accesories needed. They use the same frame, barrel etc..
I own a Twinmaster Action and im very happy with it.
www.brocock.co.uk/twinm.htm Now, there are probably hundreds of airpistols that matches your wishes but these two are the only ones that i can think of right now.. and these two wont cost you a fortune either.
Regards
KAT