They can do just about anything, even when you need a Windows version of something, provided one is OK with virtualizing or dual booting. Certain business class software is still Windows only, although I find these are more niche products than they are common business class software. For example, Autonomy HP's TeleForm and certain SQL add-ons Liquid Office, or ABBYY's FlexiCapture Professional. Certain SQL implementations may require a specific OS that may be more likely to be Windows-based.
I have Windows 10, Windows 2012r, Windows 8.1, Windows 7, Windows XP, Windows 2000, Windows 98SE, Windows 4.0 NT, Windows 1, Ubuntu, Kali Linux, Red Hat, OS X 10.12, OS X 10.11, OS X 10.10, OS X 10.9, OS X 10.8, OS X 10.7, OS X 10.6 Server, and several other OS' I am forgetting on my Mac. Some for work and some for pure amusement!
The quality of Mac vs. Windows Office seems to shift. I thought Office for Mac 2011 was far superior to Office 2010 for Windows, although I can't say I have a strong preference one way or another for either current version. And from the Windows side, I thought 2007 was superior to 2011/13/16 and still use the 2007 version of Vizio as I strongly disliked what came after. And speaking of Visio, that is one limitation you will have without putting Windows on a Mac unless they recently released a Mac version of it. BUT, OmniGraffle (Mac-only software) is IMO superior anyway. Access is another you may need an open-source alternative to (not sure if there is for Mac?)