What is/isn't fun for driving is a very personal thing. Personally, I find driving the Amalfi Coast/Drive a blast (but I have done a lot of hours in race cars). Sure, you need to concentrate and pay attention (for example, as the road winds along the coast, you can often see the road on the other side of the inlet and get an idea of upcoming traffic).

What is probably most disconcerting to many is that the locals use the full road to hit the apex of the corners and thereby move along at a pretty good clip (and they know the road and what's on the other side of the bend). The car of choice for many of the locals is a Smart Car whose short wheelbase helps for a fast drive. If you decide to drive (and IMO it really is the only way to get around there), just drive within a pace that you are comfortable with and if traffic backs up behind you, let them pass in places where it works, don't feel a need to drive like them unless you are comfortable doing so and stay within what is comfortable. You'll be fine.