The CD32 was more of a success than the CDTV, and I purchased one at launch, but sadly it came too late in the Amiga's life as the next generation of consoles (PSOne) were about to appear and blow it out of the water.
There were still some great games released for the CD32 that were worth playing and took advantage of the controller well. The default Commodore CD32 controller was quite bad though, but Competition Pro made a much better one that used the same design as their SNES and Genesis pads of the time and was really nice to use.
A couple of CD32 games that stick in my mind as being really good are Guardian (like a 3D version of defender with SNES Starwing style graphics), and Diggers (a nice mining strategy puzzle game). The CD32 version of Wing Commander was quite cool too. Many games initially released on the CD32 were later ported to the A1200 as AGA versions though.