I didn't have any issues.
I was playing Halo and 2042 all weekend on live and never noticed an issue. Now I'm seeing Kotaku scream about a 36 hour outage.
Also I'm 99% sure that your "home" console will always have access to what you bought. The people who run into problems are sharing games across multiple consoles, so yes, your non-home console isn't going to work in this case. Funny how so many articles fail to even bring this up.