I think that needs for clustered/not clustered indexes must come from design, if is the case of a process oriented system like OLTP, indexes must be used to minimum, because...
The lock manager sometimes take it's decision even if you've specified the lock hint. I develop an OLTP system and got experiance in SQL Server 7 locking issues.