I'm such a hopeless romantic and I think proposals are the one time where guys can really step outside of their comfort zone and do something sweet/romantic/creative to really WOW their significant other and sweep them off their feet (and have them say YES!). I love listening to proposal stories. But it's even better when you don't just hear the story, you can SEE it for yourself.
Some sweet proposals captured on video (these ones will make you cry):
Lucky: A Love Story
Movie Trailer Proposal
On a cute, geeky, lighter note:
Super Mario Proposal
I found a blog dedicated to video engagement proposals!