Spotlight for SQL Server LockType explanation required
Shared database locks are normal, simply meaning a connection is open in that database context.  That lock prevents another session from performing an operation like dropping the database while it's being used.

A session AWAITING_COMMAND that is blocking other sessions is an indicator the session still has an open transaction holding a lock on a resource (probably not database) that is incompatible with the other session's requested lock type.  That resource is typically a table or row but you mentioned that's not the case here. You can query sys.dm_tran_locks to identify granted and waiting locks on resources for each session.  I expect Spotlight would use this or similar a DMV.