No you didn't waste your money
8800gtx > HD2900XT
HD2900XT also consumes a lot of power and produce a lot of noise
$400 for a top end card? Can't argue with that.
You can get 8800GTS 320MB for $260 and it is a top end card
And the cheapest HD2900XT on newegg is $420 not $400