The best surfing game out is youriding.com. They just came out with a new version that allows you to switch to "tube vision" while in the barrel. There are tons of waves broken up into zones all across the world to master and plenty of achievements to keep you busy for months. Live contests, "respect", rider personalization and special moves. Check it out
KSPS for GameCube was the best IMO. It had real surfers with real breaks and not a bad soundtrack. You might be able to find it on ebay, but its not close to next-gen. Or if you're lucky maybe you could score a copy of T&C Surf Designs Wood & Water Rage for NES, haha.