"Had a 'debate' with one guy who uses it as back end for web server systems."
That I wouldn't do, unless as you say if it is going to be used by only one person

Even if it was just a handful of users, I would have gone with MSDE (now SQL Server Express edition).