I overclocked my N900 to 850MHz ... It has undoubtedly become faster .. opened openoffice in 2 mins ...
I did not find any issue yet like heating ... battery is always an issue with N900 and hence I prefer to keet it charged always ...