I had occasion to try Mobile Hotspot for the first time last night. My internet at home died and I tried it. I was unable to get an IP from the N900 on my Linux machine (Gentoo), like others above have mentioned, but on a Windows machine it did work fine and I was able to surf the net.

I'm not at home now so I can't give specific details about it.