Yeah, looks like if anything happens Banjo-Kazooie wise, I'm thinking it would be next E3. Not holding my breath for showing up in a Nintendo Direct before then.
As for Sword & Shield--I stuck with consoles after the GBA, and wished I could play Pokemon on consoles--just imagining how better the graphics and animation could be. When announced for the Switch, was pretty excited, but given my history, I was only concerned with whether all my Gen 1 and 2 Pokemon would be in it. Back then, it was a sure-thing, the only question is if it was Go/Let's Go compatible. So I completed my Go Gen 1 dex just in case, spent so long even though I wasn't a fan of Go itself. Once it was announced there'd be Go compatibility, but no national dex, and the graphics/animation is no better than the portable games, it was the worst case scenario for me. So, happy for the fans who are looking forward to it, but disappointed a) not interested in getting Sword & Shield myself and b) GF will make so much money they won't care about any of the criticism. It's a vicious cycle, but one I've accepted a long time ago.