What negative impact can occur if I detach a Sharepoint content database file location via SQL?

The end goal is to move the MDF file of a non-critical Sharepoint site collection to a different drive. The database server/name/etc… is going to be unchanged.

Microsoft basically states that the official way to move a database is to remove it from Sharepoint, detach, move, reattach and then re-add the collection to Sharepoint.

However, if we are just moving the MDF file what can go wrong to just Detach, Move and Re-Attach? Even though Sharepoint is a very beefy web application, does it really get involved/dependent in the database settings? Application/Database server duties like this are normally handled separately.

Please explain what issues moving an MDF file location this way would cause.