This won't work with non-static IP's and getting the same prefix back though,
Sure; but this would probably be sufficient for the average John Doe, right?
They found MSN, Yahoo, Google, KaZaA etc. Friends tell that is the trick to it, if there is interresting enough content even 13 year olds can configure it.
Right. If we assume IPv6 would have killer applications which would make the users really eager to get it, sure -- everything would probably be simpler. But in the absence of such, we need to forward without them :-).