This looks to be a fine piece -- especially if you can get it for about the price quoted. Beretta does make good guns. The rotary barrel feature is a little strange, but that's OK.
It does look like Bretta has solved the problem of the awkward grip of the Model 92. Without having one to compare it's difficult to say for sure.
What's the price of spare magazine? Does the Cougar's interchange with the Model 92 (or whatever Beretta's model designation for the .40 S&W is)? Does the package come with a spare magazine (that is, one in the gun, plus one in the box)? That's a good deal if Beretta does that. (Then you only have two more to buy.)
Basic rule for a pistol like this is one magazine in the gun and three spares. The two go in the magazine pouch and the third is used to rotate magazines (if carried for duty use) or as a backup in case one of the others starts having problems.