Well, relax. You really don't give much information to help you with your problem. By a quick look into Canon's specs for the R506 I can immediately see that it writes either AVCHD or MP4 container video files. So, yes, you can directly access these video files on your SDcard without the need for a transfer program. You can try, it's easy! Microsoft's media player is crap, so in case you encounter playback problems, get a decent player, such as the free VLC. It handles AVCHD and MP4 with their included H.264 video streams well. Something Microsoft has problems with for no reason.
The transfer program is for those that don't know how to navigate especially the AVCHD directory structure and which don't want to directly deal with segmented video files when shooting long clips that would result in files larger than approximately 2GB.
Personally, I would stay away from 64GB cards as there are many problem with them due to their different file system. I know of at least one action cam company that inoffically instructs its dealers to better go for 32GB, as these have the normal FAT32 file system.
On another note, class 10 really doesn't mean anything beyond useless theoretical performance. For instance, SanDisk boasts on the package of its Extreme 32GB microSD 80MB/s. My real world measurement says 7MB/s writing speed. Companies boast their fictitious read performance, but in your camera write performance is crucial. My suggestion is to not go for the cheap junk that is sold on eb*y and everywhere else, too much fake goods or refurbished junk sold there. Get a decent quality card from a brand manufacturer and buy it through a proven retailer.
At least for the HF G30 I know from my personal experience that Canon does a really good job on its SD card subsystem. This copes with really all the class 10 junk out there really well, even at high bitrates such as 35Mbits for 1080p50.
