The place is beautiful and is very convenient if you use own transport. It's easy to get to Coronet Peak by using NZSki bus from there or from the Coronet Peak Hotel which is further up the hill.
Little issue will be to buy tickets to the NZSki bus. Tickets are not sold by Shotover Top 10 Holiday Park and you will need to buy it in Queenstown or at the following hotels: Coronet Peak Hotel, Shotover Lodge.
Here's the link to mountain bus details: http://www.nzski.com/guides/2011/queenstown/snowline.jsp
It's very convenient even if you travel with children and don't hire a car or don't have your own transport.
Some photos of the Shotover Top 10 Holiday Park and view from it: