Holland has usually been rather generous with regards to the EU (certainly under Paars), even the public, and if the campaigning had been handled better I could well imagine the result swinging the other way. As it was, Balkenende and co pretty much threw in the towel instantly while most political elements, ranging from Wilders to SP worked against the constitution, inertia did the rest; though admittedly, you're probably correct in saying opposition had little direct influence on the result and just hitched a ride on a sure win.
Certainly everyone disliked Balkenende and anything he and his cronies supported enough to vote against what could be seen as "their" referendum largely out of spite. I'm certain any decent politician and cabinet could show benefits, or at least have the spine to get something from the EU rather than constantly conceding on any issue. Balkenende doesn't have that spine, nor does his cabinet.
I agree with your statement about there being little return for investment, as I stated in an earlier post. What with all the decisions being taken over our heads, with most money spent going elsewhere, it's easy to see a number of reasons people would vote against more EU presense in dutch politics.
It's all good and well wanting to expand the EU and support poorer nations, but that has no use whatsoever if you alienate the people actually paying. Unfortunately, this is exactly what has happened.
Bookmarks