I alternate coffins and statues around my Trade Depot and along the main entry hall. These are for the common dwarves and their pets... and also lets any visitors to the fortress know that this is a
working fortress and there's no easy living here.
I also have a small 3x3 graveyard stockpile assigned outside, to help with quick cleanups after heavy fighting. As often as not any dwarf corpses rest there for a while before they're brought into the fortress for final internment.
When my dwarves either earn a name or reach "legendary" status they earn personal tombs near the back of my living areas. Truly heroic dwarves (heroic in that they impressed
me) earn tombs in the living areas sited so that everyone going to the dining hall/zoo/well pass by and can remember. Unless they didn't survive their heroic deed, in which case they get a room dressed out as a tomb but without it actually being "assigned" to them 'cos I can't.
Nobles get tombs in a room off their bedroom. When the coffin is filled I de/reconstruct the tomb, throwing the bones in a common coffin in the hall and re-assign it to the replacement noble, along with the bedroom, office and dining room.
I don't really care if it gives their grieving lovers bad thoughts as they're almost invariably other nobles and I'll quite happily fill
their coffins too!