The decision whether to cancel a flight or not is quite different where you are just giving your mates a joy ride, and can say "weather not good enough, lets go and have a drink in the clubhouse and come back next weekend", compared to paying 'passengers' turning up and expecting to be taken
Each to his own I guess.
I have never flown any kind of commercial flight as a pilot, legal or otherwise, but have never once had a problem cancelling a flight for weather or technical reasons and have done so several times in very pressing circumstances.
I am also absolutely sure I would have no problem doing so if I was being paid.