'I'm in that strange place between knowing which technology my future lies in.'
A bit awkwardly phrased, but I completely agree with the feeling. I have it too.
I am in no doubt that there will be a permanent need for good developers/programmers. The issue, for me, is being able to deliver whole projects being a one-man show. With Notes this is feasible, with other technologies, it seems to me one needs at the minimum a small team to be able to deliver a software. It's definitely the case for Sharepoint. There are too many simultaneous learning curves for this.
I enjoy being independent too much; going back to being an employee is something which I really want to avoid...
And Jake, I come to your site not only for the technology, but also for these candid glimpses into your mind - it's nice to see that I am not alone with these thoughts!