NO! Do NOT use mounting tape. What WILL happen in the long run is the adhesive will fail due to the heat in the car and breaks down. Then it will melt and get all over your dash making a mess. Been there, got the t-shirt. And yes, before you ask - I used that exact tape you suggested. Every tape I've tried has failed.
The BEST solution is to use a high quality suction mount and mount it properly. What that means is the windshield and the suction cup have to be completely clean. Not the slightest bit of dirt can be present. Otherwise air will leak in and the mount fails. I did this a year ago and the mount works perfectly.
This is the mount I used and is available on Amazon: https://www.amazon.com/gp/product/B00KC6BCVI/ref=ppx_yo_dt_b_search_asin_title?ie=UTF8&psc=1
I was able to unscrew the camera mount plastic piece and attach the one that came with my camera. Worked perfectly and allowed for the camera to be closer to my windshield for my windshield has a steep angle to it. (Ford CMax)