It's one of the few domestic cars of recent date that has a timing belt. The timing belts go at 60,000 miles like clockwork. Thankfully the engine design prevents piston crash. Not an easy to work on engine, nor is it particullarly popular. I had a 1993 Grand Prix GTP with the 3.4 Twin Dual Cam V6, It was nice, my version made about 210hp, later models were up-ed to 215hp. Make sure that the car has been properly maintained. They did rev up to an almost 7000 rpm red line, which is not bad for V6. The power was adequate, but nothing to really write home about. One of the interesting facts was this engine was able to be combined with a 5 speed manual through 1993.
I dont know how good a deal the car is, the only vehicle that I would consider with a 3.4 DOHC V6 would be the later model Cuttlass Supreme convertibles.
If you are looking for GM FWD performance from the early 1990's. Try a 1992 and up Bonneville SSEi with the Supercharged V6 or any of the Buick Regal GS's from the early 90's with the 3800 V6, these feel more "lively" than the 3.4 DOHC's, and it's a way more bulletproof engine. There were a few versions of the 2.4 Litre Quad 4 that made from 180 to 190hp, theese were available in the Oldsmobile Acheiva SC/SCX and Grand Am GT , most of the times they were combined with a manual transmission, they were great performing little cars. You can also look into a 1993 and up F-body, bar none, these cars are now a great performance bargain.