Is a boxster with 204 hp the right choice?

We’re just thinking of buying one of the first boxsters with the small machine. Does anyone have experience of what should be considered best? Are there problems with the machine. Automatic OK? Small machine and automatic – how does that work? Does this still make fun? Is there a purchase advice for the first models? The car is from 1997. For more infos thank you!