Ok everybody, thanks for all the help! I followed your suggestions and did a "factory reset" on the advanced settings page and after it booted me off I went to sleep. When I woke up I forgot about it and basically left it alone almost a week. Today I was browsing on my phone for a few hours and by chance noticed I was actually connected to the ASUS Wifi (192.168.50.x) instead of the BELL Modem Wifi (192.168.2.x), and there was no problem at all!!!!

I connected my laptop to the ASUS Wifi and now I'm typing this post!

I'm also able to access my Bell Home Hub at 192.168.2.1 while I'm on my ASUS Wifi. I enabled "login from WAN" on the ASUS and so if I'm on the Bell Wifi I can access my router at it's IP on the Bell modem/router at
https://192.168.2.93:8443 (default port 8443 for the login screen). This is exactly what I was expecting and what I experienced out of the box with my Linksys at work.
So basically I think the ASUS router was returned and repacked by the store, and some settings may have been screwed up. Something definitely was wrong with it out of the box. What a freakin' waste of time trying to figure this out.

Anyways I'm glad it's resolved, I thought I lost my mind there for a second, and I didn't really want to return it.

Thank you all for your help. I've never encountered this before and didn't imagine that a store-bought brand new device all wrapped in plastic would behave like this, so I assumed something was faulty with either the ASUS or the way my Bell Home Hub handles routers. You live, you learn!