Alexey has an interesting story about big cost saving (money, time, simpler architecture) NHibernate has enabled for his team.

I recall doing an integration project once where I was able to move the database from an intermediatory SQL Server to DB2 on AS400 by changing a few lines in the configuration files (the client decided not to go with the approach, though, since it didn't fit their ESB plans).