Not sure if anybody's mentioned this yet, but you can dual-boot and just install Windows on a Mac -- then you get the best of both worlds, right? Unless there are hardware issues, I guess. Anybody here use a Windows partition for work? I'm curious to hear about it.
Boot Camp is how Apple delivers drivers for Winders that are compatible with the HW it installs on. But, really the question is if the HW on the Mac is adequate for the PC tasks. A high end, custom PC will often be more capable than Macs in the same price range, but this is typically only an issue for the most demanding of power users. Hopefully, Apple will return to a more modular approach and support third party HW upgrades to higher end Macs in the near future in order to fend off this unfortunate disadvantage.
I have several Mini at work that dual boot using Boot Camp, Win 10 runs great on these but I don't really use them for intense graphics tasks like CAD.
A lot of talk in this thread re: Office. To re-iterate what others have said, Mac version of Office is more than adequate for 95% of users. I do have some automation in Excel VBA that works just fine on Mac (Office 2016), but understand there are some gaps. But in my experience, I have been able to do everything I need on Mac Office.
For me, the kicker was frustration with maintenance issues on PC, I was always battling virus\malware, slowdowns, crashes, you name it. How many times I re-installed Windows to clean things up. I tinker with *nix and Windows machines all day at work (from my Mac) and I prefer a personal machine that just works. On several occasions, I have replaced HDD, migrated to new machines, or simply rebuilt my Mac using Time Machine backups. My experience with PC was frustrating as I would typically have to re-install all the apps (and find the license keys). With Macs, Time Machine has cared for that very well, within minutes of completing a restore, I am up and running as if nothing happened.
There are alternatives for virtually anything available on PC. It may be a different publisher, it may work different, but it often is a more pleasurable experience. So, if you go this route, the best advise is get used to Google searches for "Mac alternative to [insert PC program]".