The activation to sleep works differently than the normal, the script is detecting the keypress rather than being told the bed was activated. It works this way so you don't have to aim at the bed to bring up the sleep menu.
Which survival mod are you using? Does SYS work without it?
The spell effects you are seeing aren't related to SYS - maybe they are used by the survival mod to restore fatigue/hunger or something.
Oh, well that explains something (though not quite sure what, exactly).
The survival mod I'm currently using is http://www.tesnexus.com/downloads/file.php?id=37088, and no, SYS doesn't work with it off. That was the first thing I thought of as well, since in my previous playthroughs I had been a die-hard user of http://www.tesnexus.com/downloads/file.php?id=15773, which has a SYS patch (as you know), and I never had the least problem.
What I am now thinking is that maybe it's a conflict/bug in http://www.tesnexus.com/downloads/file.php?id=37382, which, as a consequence of moving the start cell, places a bedroll which is scripted to move you to your chosen start location once you've completed creating your character (and choosing a start location). It seems unlikely, but it's the only possibly-involved-mod that I have not tested without (due to the inherent difficulty of relocating my entire start if I want to keep the game, not to mention the inherent tedium of going through the tutorial dungeon for the umpteenth time, though I suppose with T.I.E. it won't be so tedious as normal but still), and I suppose it's remotely possible that the script placed on the bedroll has somehow carried over to all beds and overridden the sleep menu call detection of SYS.
In any case, here's two screenshots of debug 9, one before I got into bed and one while I'm in bed, trying vainly to activate the sleep menu. Strangely, what seems to trigger getting out of bed again is calling up the wait menu, cancelling immediately, then hitting spacebar a couple of times (though I suspect that last isn't necessary; I had the impression that I would have got up in a few seconds anyway after cancelling the wait).
http://img402.imageshack.us/i/schermafdruk1k.png/
http://img860.imageshack.us/i/schermafdruk3.png/
They don't say a thing to me, plus they both look the same to me, but maybe you can see something I don't. Don't be fooled by the fact that these pix were taken in a mod-added house; not only have I checked in the CS and the beds are dead normal stock beds, but just to be sure, I also went to the Count's Arms (in the nearest city) and paid for a room, for all the good it did, which was none. Sorry, I get cranky when I'm overtired (which I am both in-game and irl atm :snoring: )
My current load list:
Spoiler Active Mod Files:00 Oblivion.esm01 Jog_X_Mod.esm02 All Natural Base.esm [Version 1.2.1]03 Cobl Main.esm [Version 1.72]04 cyrodiilupgraderesourcepack.esm05 curp_controller.esm06 bab.esm [Version FINAL]07 TIE.esp [Version 1.44]08 cyrodiil transportation network wz.esp09 Enhanced Economy.esp [Version 5.2.2]** cobl races tnr.esp [Version 1.53]** cobl races tnr si.esp [Version 1.53]0A unofficial oblivion patch.esp [Version 3.3.3]0B Oblivion Citadel Door Fix.esp0C DLCShiveringIsles.esp0D unofficial shivering isles patch.esp [Version 1.4.0]0E SM Plugin Refurbish - SI.esp [Version 1.30]** atmospheric loading screens - original text.esp0F All Natural.esp [Version 1.2]10 All Natural - SI.esp [Version 1.2.1]11 immersive interiors.esp [Version 0.7]12 immersive interiors - lights addon.esp [Version 0.7]13 dexwoodfamilysaga.esp14 Storms & Sound.esp15 All Natural - Real Lights.esp [Version 1.2.1]16 WindowLightingSystem.esp17 snr mage guild uff.esp18 snr citizens uff.esp19 snr villains uff.esp++ Item interchange - Extraction.esp [Version 0.78]1A kalikuts_bracelets.esp1B Streamline 3.1.esp1C Timekeeper_Advanced.esp1D dynamic map.esp [Version 2.0]1E P1DseeYouSleep.esp1F cuo_merchantsguild_safe.esp20 Map Marker Overhaul.esp [Version 3.8]21 Maps!.esp22 DLCOrrery.esp23 dlcorrery - unofficial patch.esp [Version 1.0.4]24 SM Plugin Refurbish - Orrery.esp [Version 1.11]25 DLCSpellTomes.esp++ dlcspelltomes - unofficial patch.esp [Version 1.0.1]** grimbotsspelltomes.esp++ bab.esp [Version RC1]++ tff_races_base_rsm.esp26 tff_armor_base.esp27 tff_clothing_base.esp28 tff_clothing_si.esp29 uff & rm extra robe pack.esp2A uff & rm elegant vests.esp2B uff - celtic witch robes.esp [Version 2.1]2C slof's oblivion robe trader.esp2D Cobl Glue.esp [Version 1.72]2E cobl si.esp [Version 1.63]++ cobl tweaks.esp [Version 1.44]2F babshop.esp30 arborwatch.esp31 Better Benirus Manor.esp [Version 4.71]32 Better Benirus Manor - AN Patch - Natural.esp33 delivery_job.esp [Version 1.1x]34 FishermansCottage.esp [Version 2.1]35 leyawin player house for sale.esp36 Princess IC Waterfront Shack.esp37 Region Revive - Lake Rumare.esp38 AFK_Weye.esp [Version 2.2.COBL]39 Side's Bravil House.esp++ Side's Bravil House (COBL).esp3A side's bruma house.esp [Version 1.1]3B side's bruma house (cobl).esp3C Side's Cheydinhal House.esp [Version 1.01]++ side's cheydinhal house (cobl).esp [Version 1.0]3D Side's Skingrad House.esp [Version 1.0]++ side's skingrad house (cobl).esp [Version 1.0]++ SYS Patch for Sides Skingrad House.esp++ SYS Patch-Leyawiin Player House for Sale.esp++ SYS Patch-Arborwatch.esp++ SYS Patch-Side's Cheydinhal House.esp3E thievery.esp3F thievery - EE patch.esp [Version 4.2]40 uff gypsy market.esp41 dlcfrostcrag.esp** dlcfrostcrag - unofficial patch.esp [Version 1.0.5]42 SM Plugin Refurbish - Frostcrag.esp [Version 1.2]43 cuo_bravil.esp44 The Lost Spires.esp++ The Lost Spires v14 Delayer.esp [Version 3.1]45 blood&mud.esp46 origin of the mages guild.esp [Version 7.3]47 AFK_Weye - Oblivion XP Patch.esp [Version 1.0]48 cuo_bruma.esp49 cuo_chorrol.esp4A cuo_leyawiin.esp4B DID3_DoubleTrouble.esp4C harvest [flora].esp [Version 3.0.0]++ harvest [flora] - shivering isles.esp [Version 3.0.0]4D harvest [flora] - dlcfrostcrag.esp [Version 3.0.0]4E q - more and moldy ingredients v1.1.esp4F Pitcher Plant and Lily Ingredients.esp50 birthsigns expanded.esp [Version 3.21.]51 HUD Status Bars.esp [Version 4.1.1]** obliviousterrainreplacer.esp52 Storms & Sound - Blood&Mud.esp53 Alternative Beginnings.esp [Version 1.1]54 Basic Primary Needs.esp55 suprememagicka.esp [Version 0.90b]56 sm_shiveringisles.esp [Version 0.90]++ sm_dlcspelltome.esp [Version 0.90]++ sm_cobl.esp [Version 0.90]57 sm_enchantstaff.esp [Version 0.90]++ sm_scrolls.esp [Version 0.90]++ sm_sigilstone.esp [Version 0.90]58 MidasSpells.esp59 Oblivion XP.esp5A grandmaster of alchemy.esp5B Ethereal - Eyes.esp5C hidden_elves.esp [Version 1.2]5D Blood&Mud - EE patch.esp [Version 4.2]5E Rumare-AFK_Weye Patch.esp [Version 2.0]5F Storms & Sound - AFK_Weye.esp60 clocksofcyrodiil.esp61 cobl races.esp [Version 1.52]** better redguard v2.esp62 Benjamin the Donkey.esp63 GrindBones.esp64 snr thieves guild uff.esp65 CheeseCutter.esp66 Maigrets Sable thePanther.esp67 Reading Takes Time.esp++ Item interchange - Placement.esp [Version 0.78]++ Item interchange - Option, Ingredients in Bulk, reduced.esp [Version 0.78]++ Item interchange - Placement for Frostcrag.esp [Version 0.78]++ cobl filter late merge only.esp [Version 1.53]** All Natural - Indoor Weather Filter For Mods.esp [Version 1.2]68 Bashed Patch, 0.esp
What I might try later today (Saturday) is replacing Basic Primary Needs with Vim and Vigor Advanced to see if that helps. I may also check to see if and when Alternate Beginnings can be disabled but I suspect the answer is "not till after you find the AOK" or alternatively start a junk game with a "move you to the end of the tute dungeon" quickstart, dash to the Merchant's Inn, and see if I can get some rest.
But thanks so much for any possible help; as others have said, this is a small mod that it seems like you should be able to do without, but it adds so much 'feeling' to the game that one would really rather not do without it if this issue could be resolved.