Hello Will and welcome to the club.
You had an 182 in the past so I won't say a thing regarding how hardcore these cars are in comparison to your civilised golf
Expect a thirsty engine, no power/torque at the low revs (below 4k), silly ratios (to help keeping the engine on the boil for the above mentioned reason) and rattling. As a bonus you get no tuning options unless you have deep pockets!
If you are willing to live with the above then the 197/200 is a magnificent drivers car and a bargain for what it is! A small cheap hatchback with an excellent chassis.
Btw I'm sure you'll hear stories about faults, break downs etc, do not allow them to put you off. All cars have problems, it's not only the Clio!! Yes they have been cases with gearboxes and engines not delivering the 197bhp and steering racks and melting steering wheels and bubbling tailgates and slave cylinders and whatever. It's luck, like every single car out there...
Good luck with the search