I have just gone the other way, from a 197 to a Golf R32. The Clio was a great little car, but it only does fast. You can't really stick one in 6th and cruise down a motorway in one, it belongs on a B-road or a track. My favourite giant-killer vid is this one, where a Clio driver who appears to know the Nordschleife very well hassles a Porsche driver who obviously doesn't!
Thats why I went to an R26, the clio is a great B-road/track car, but for everyday and motorways its no fun. I do miss mine, and there is a supercharger that may be ready next year, so might end up back in one for a bit of super-fun! lol
The main issue I had was the 4K rpm on the motorway, which a supercharger wouldn't fix. In fact, the car would be even louder, wouldn't it!
You'd probably need to get a longer 5th and 6th gear fitted to make it an everyday car. There was a guy on 197.net whose car went bang on the rollers after having a supercharger fitted. Never really heard anymore about it after that.