If you want to be closer to the water, feel the force of the wind and spend more time in the open air you'll probably go for a sailing yacht.
If you fancy comfort and prefer to have a lot of space for your family and friends, a catamaran might be the right choice. In addition, catamarans are much more stable on the water. But keep in mind that it requires some skill to move this hulking vessel around, especially in tight spaces.
Motor yachts are great for luxury vacations. But their mileage range is rather limited and fuel consumption is something to be aware of.