The Wife's CTS had flappy paddles.  I viewed them as a gimmick until I started using them.  Granted, I usually drove it in D, but it was kind of fun to drive in M from time to time.  In the mountains it was very convenient, and I'd down shift at other times one notch or two to engine brake a bit.  That wasn't really a performance car, it weight nearly 4,000 pounds and had a 4 cylinder engine.  It would hit 60 mph in the low 6 second range.  The transmission had a torque converter, GM has until recently shied away from the DCTs.
One nice thing when you switched to M the dashboard would change and give you the gear you were in in the HUD and between the speedo and tach.
I doubt many people pay any attention to the tach these days.