For digital clocks, there are a bunch listed as "Sense Analog Clock." I know that makes no sense, but they show up as the 4 digits. Or, you can try Go Weather, which has clock widgets that also will pick up weather if you are on wifi. There are many different widgets for Go Weather and also many ways it will show you the weather.
For SMS, I use TextPlus. The texting is free, and when you sign up, you actually get a phone number, so people can send you texts. Of course, you must be on wifi in order to send and receive. With TextPlus, you also have the ability to make and receive calls. I was able to do that once, but have had trouble repeating it. You will need to be able to connect a headset through USB. You would need to be able to enable USB host, which Nook Color Tweaks allows. When I figure out which set up works for me consistently, I will surely post it. TextPlus gives you a few free minutes, then you can buy them at about $.01/minute.
As for the Office Pro app, if you bought it from the B & N Nook store, I don't think you can put it on CM7. If anyone knows how, please correct me. Anything you buy on the Android Market will be downloadable, generally, as long as you always log in with the same Gmail account. So, if you later move to CM9, you will still be able to use most apps you purchased on the Android Market on CM7. There are a small minority of apps that may be tied to the particular hardware you are on, and may not be available if you change either your Nook, or possibly the operating system on it. I have found that occasionally, as I have an Android phone and now my Nook. But most will work.
What do you need the office app to do? If it's for reading pdfs, there are apps that handle that that are less expensive than the regular office apps. There are also free office suites as well as the paid ones on the Android Market. Often the free ones won't allow you to modify or make a new document on your Nook, though you'll be able to read them for free.
As a side note, I am running both CM7 and CM9 from one microSD card from this thread: http://forum.xda-developers.com/showthread.php?t=1448186. Sorry, but my browser is not letting me put the link in. I also have another microSD card that has Miui on it. You can find that in the same sub forum at Xda-Developers. The CM7/CM9 card is a 16GB card. The Miui one is an 8GB card.