From 1988 to 2007, the Australian Open used Rebound Ace surfaces. In mid-2007, the tournament organisers decided that from 2008, the tournament would instead be played on Plexicushion surfaces. From memory, the lead up tournaments in Hobart and Sydney formerly used Rebound Ace but subsequently changed to Plexicushion following the Australian Open’s lead.
When it comes to hard courts there are lots of different names for the surface when you get specific. Some indoor hard court surfaces are known as “Premier Court” for example, and as far as outdoor hard courts go, in addition to the general name of “Outdoor Hard Court” there are more specific names such as “Plexicushion”, “Cushion Plus”, “DecoTurf” (US Open uses this) or “Plexipave” (which is the surface at Indian Wells).
To answer your question – I believe the year-end WTA Championships in Istanbul, Turkey still use the Rebound Ace surface. That is the only current professional tournament I’m aware of that still uses it, though. DecoTurf seems to have become the preferred surface for many professional tournaments because of the speed it plays at and the bounce it gives is favored by many players. Back when the Australian Open used Rebound Ace there were some complaints from players that the surface got too hot and sticky and they didn’t like the way it played.