Hi Stu,
And first of all welcome aboard.....
I also have an early 996 C2 without tc and my previous two cars were an Audi A6 2.8quattro and then a 964 C4 so moving to a rear-wheel only drive car I was naturally more cautious.
However, after 4+ years of daily driving (rain/snow) and a few track days (dry/wet) I have found the car to be nothing less than excellent for what it is but agree with the previous comments about being more cautious under poorer conditions.
Of course, you need to be more careful under poor conditions, especially when you are 'learning' to drive a car that in reality is a completely different setup to one you have previously got used to - the characteristics will be VERY different on the limit, but most people wouldnt drive like that on a public road.
Driver instruction and track-days will let you explore what the car can do legally and in safety. Brands Hatch have a Novice Only track day coming up in June so it might be worth considering that.
All the best and enjoy your new car!
Rob