So the flex joint is gone in my SSEi and it sounds horrible. The new pipe from the dealer is almost $400 which is a bit much I think. Is there anywhere that sells a replacement? I'm not really looking for performance or anything, just something to replace the stock original piece so my car doesn't sound horrible. Where would be the place to get this at? Thanks in advance.

ZZP sells them for about $200 IIRC, theres 3800performance.com too

Most muffle shops can get you a new flex pipe and install it for you fairly inexpensively. You don't need to replace the entire down pipe, just the flex pipe.

A exhaust shop is your best bet. Otherwise, Auto Parts Fast at RockAuto had this.

2000 PONTIAC BONNEVILLE 3.8L 231cid V6 FI Supercharged (1) : Exhaust : PipePriceCoreTotalWALKER Part # 52270 {Front Pipe}
SE Models
$119.79$0.00$119.79

Quoted for truth. Had mine replace at a muffler shop on my old car for roughly 70 bucks (labor and parts).

Thanks for the replies, I'll look into that one at rock auto for $120, might be worth getting. Need some new front brakes soon too....