There is actually more information in sys.databases than there is/was in sysdatabases and it's a bit more straightforward - no status bits to deal with. You are looking for the column named state. Restoring and Offline are values for state in that view. And there is another column called is_read_only.
You can find the documentation here:
sys.databases
Sue