I'm not happy that the lockpicking skill investment can be bypassed via pounding a container/door repeatedly with spells (which, unlike weapons, doesn't cause costly durability damage to your equipment).

Damaging items that are inside containers that have been forced open is one way of addressing that, but the problem is it doesn't resolve the issues with forcing open doors.