Rented a kayak for a couple of hours. Was overall a good experience. The business is located near to shops, art studios, restaurants and the Granville Island market, so if you're with a group that doesn't want to get on the water, they'll have plenty to do while waiting for you! Before 6 pm that is. At 6 the market closes and although there are restaurants and live theatre in the evenings, the place starts to feel deserted.
The paddle was good, in two hours you can see some of downtown, Stanley park and the north shore, or you can opt to head east for more urban views.
I recommend going early in the day for calmer paddling, and early in the week (Tuesday) for discounts. Under $50 for a two hour rental including tax. Staff were friendly.