I absolutely love water parks, and think they're quite under-rated really. I've visited Wet n' Wild in Florida a few times and LOVE it, the Bombay Drop (or something similiar) is far scarier than any roller coaster I've ever been on.
In Europe there are many decent water parks in popular holiday destinations going by the 'Aqualand' name, and are extremely popular in the summer.