I'm confused, sounds to me like you're after a PC (given all the Windows questions) rather than a Mac, why are you considering a mac?

There is Quicken mac which would replace Microsoft Money, it even imports from it.
There is Omnigraffle which produces much sexier diagrams than I've seen visio produce.
And you shouldn't have any problem with the VPN under OS X.

OS X all the way baby!